Returns unique rows in the provided source range, discarding duplicates. Rows are returned in the order in which they first appear in the source range.

How To Use in Sheets


External Links

Google Sheets - Remove Duplicate Data with the UNIQUE Function

Duplicate data can be a chore to find and remove in a spreadsheet. The UNIQUE function does it quickly and easily.

4Better Sheets Tutorials

Search and find duplicates that are spelled differently.
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.


4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.