Verified answer

In order to approach this properly, we need a little more information. By UNIQUE rows, do you actually mean 'CELLS'?.

If you are referring to complete rows, then each cell in the row must be unique in the column it is in.

For example, assume:

A1 contains 'Red' and B1 contains 'Blue'

A2 contains 'Red' and B2 contains 'Black'.

Going by the 'cell only' theory, using column A, these two are duplicates.

Going by the 'entire row' theory, these two are not duplicates.

You can try this method. Let’s say your data is in column A, starting with A2 (A1=Header). In next available column you can enter this formula. Let’s say in this case column B (in this case From B2 to B11) =COUNTIF($A$2:$A$11,A2) Replace $A$2:$A$11 with your actual range. Then filter Column B, filtering out value 1. Select remaining cells, right click -> Delete Row.

Let said column A has these value

1

1

2

3

paste this in column B1 to B4

=IF(COUNTIF($A$1:$A$8,A1)=1,"x","")

B2 and b3 should has a x value

Do a sorting, all Xs should be at the top or bottom, then you can just highlight them and remove it.