Duplicates
Find, highlight and remove duplicates in Google Sheets: the Remove duplicates menu compared with UNIQUE, COUNTIF rules for whole rows, and two lists compared. Every formula tested.
-
How to Remove Duplicates in Google Sheets (Menu, UNIQUE and What Each One Keeps)
Google Sheets has two ways to remove duplicates: the Remove duplicates command, which deletes rows from your data, and the UNIQUE function, which builds a clean copy somewhere else. They…
-
How to Highlight Duplicates in Google Sheets (Every Copy, Repeats Only or Whole Rows)
Google Sheets doesn’t have a one-click “highlight duplicates” option, but a conditional formatting rule with a short COUNTIF formula does the job. The formula decides what gets colored: every copy…
-
Find Duplicates Between Two Columns in Google Sheets (Matches and Missing Values)
To find the values that appear in two lists, ask for each value in the first list whether the second list contains it. COUNTIF and MATCH both do that, FILTER…