Find Duplicate Rows in a Sheet

Find Duplicate Rows in Google Docs

You can use this function as explained below also to find out duplicate rows in a table.

This requires a couple of steps:

Step 1: Assuming that our original data is in columns A, B & C, go to cell D1 and write a formula to concatenate the data in three columns. We’ll use a pipe separator to distinguish between a row like "a1, b, c" and "a, 1b, c".

=CONCATENATE(A1, "|", B1, "|", C1) – drag the cell handle to fill the formula in other cells.

Step 2: Sort the D column by clicking the header as shown in the screencast.

Step 3: We now need a function to compare two adjacent values in column D. If the values are same, one of them is a duplicate for sure. Type this in E2:

=IF(D2=D1, "Duplicate", "") – drag to fill all cells until E5.

That’s it. All rows in column E that have value "Duplicate" are duplicate rows.