Sheetwise
Google Sheets · Video available

Remove Duplicate Rows with UNIQUE

Create a separate list of unique rows while preserving your source data.

Download practice data · CSVStart the exercise

Watch the tutorial

Watch on YouTube · Short

Try it yourself

Import at A1. Put the result in E2; leave its spill area empty. UNIQUE compares whole rows in A:C. For email-only results use UNIQUE(B2:B13). Expect 9 unique rows; the 12 source rows stay unchanged.

=UNIQUE(A2:C13)

Preview the input data

NameEmailPlan
Emma Wilsonemma@example.comStarter
Noah Brownnoah@example.comPro
Mia Davismia@example.comStarter
Liam Jonesliam@example.comPro
Emma Wilsonemma@example.comStarter
Olivia Millerolivia@example.comPro
Noah Brownnoah@example.comPro
Ava Taylorava@example.comStarter
Ethan Andersonethan@example.comPro
Mia Davismia@example.comStarter
Lucas Thomaslucas@example.comStarter
Chloe Moorechloe@example.comPro

How to open the CSV

In a blank Google Sheet choose File → Import → Upload and select the downloaded CSV. Use comma as the separator. Start at A1 unless the exercise specifies another location. CSV contains input data; add formulas and controls using the steps above. Files are hosted directly here and require no shared personal Drive document.

Fictional demo data. Formulas use English function names and commas between arguments. Other spreadsheet locales may require semicolons. Check date recognition after importing.