Remove Duplicates in Excel & Google Sheets

Use formulas to get unique values, remove duplicates (keep first or latest), count duplicates, or highlight them. No signup required.

Get Unique Values

Extract unique values from a list.

=UNIQUE(A:A)

Remove Duplicates (Keep First)

Remove duplicates, keeping the first occurrence.

=UNIQUE(A:A)

Remove Duplicates (Keep Latest Date)

Remove duplicates but keep the row with the latest date.

=SORT(UNIQUE(FILTER(A:C, COUNTIF(A:A, A:A)=1)), 3, -1)

Count Duplicates

Count how many times each value appears.

=COUNTIF(A:A, A2)

Find Duplicates (TRUE/FALSE)

Mark cells that have duplicates.

=COUNTIF(A:A, A2)>1

For more lookup and data tools, see VLOOKUP, XLOOKUP, and Data Cleaning.