One, make sure the first column has been sorted. Insert two columns into the first and second columns, both: A, B, C, D column

second, the first column will be copied in column B, and down or up the wrong line.

Three, in column C, using the formula A-B, resulting in the value

Four, the use of all the filtering to sieve out the value of 0 in column C, delete the rows containing those can be.

If you are not sure, it is best to copy the table before doing.

Responders: zsmfsl - Xiu Cai III

Don't know if you can get this right?

Can be accomplished by adding auxiliary columns, assuming that the original data a,a,b,c,d in column A, starting from A2, the new add columns in column E, then add the formula at E2

=COUNTIF (A:A,A2)

Displaying the results of 1, that is, non-duplicated

Displaying the results of >1, that is, duplicated

Select the range, tap Menu - Data - Sort, so that the data showing a result of 1 is stacked together for easy deletion.