Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to filter to unique values only in Excel and Google Sheets
Excel & Google Sheets
=UNIQUE(A2:B3)Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Select an empty cell where you want the unique values to appear.
- 2Enter the UNIQUE formula, referencing the range of your data.
- 3Press Enter to see the list of unique values.
Tips
- Ensure your data range is correctly specified to avoid missing any unique entries.
- In both Excel and Google Sheets, the UNIQUE function ignores blank cells.
- If your data includes headers, include them in the range or use OFFSET to exclude them.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
Can I use UNIQUE with more than two columns?
Yes, you can use UNIQUE with any number of columns by specifying the entire range.
What happens if there are duplicate rows?
The UNIQUE function will return only one instance of each duplicate row.
Is there a way to sort the unique values?
Yes, you can sort the output of the UNIQUE function using the SORT function.