Remove Duplicate Rows in Google Sheets with UNIQUE or QUERY

This tutorial demonstrates two formula-based ways to remove duplicate rows in Google Sheets: the UNIQUE function and a QUERY. The creator shows each approach and then explains the difference between the two methods, which helps you decide which one fits your data. The video runs about two and a half minutes.

By

Removing DUPLICATE ROWS in GOOGLE SHEETS, by Amigo Data on YouTube. 2 min 41 s.

Video length
2 min 41 s
Time to do it
Varies
Difficulty
Easy
Steps
See video

What this tutorial covers

  • Removing duplicate rows with the UNIQUE function.
  • Removing duplicate rows with a QUERY.
  • Comparing the two methods to see how they differ.

More in Apps & Software

See all
1:39

How to back up WhatsApp chats to Google Drive on Android

Apps & SoftwareTechOZO
1:04

How to recover deleted WhatsApp photos, files and voice notes

Apps & SoftwareBenson Mwangi
1:26

How to make a wedding QR code for a shared photo album

Apps & SoftwareLinkly
1:23

How to create a shared album on iPhone in iCloud Photos

Apps & Softwarephoneandpctips