Duplicate rows, case sensitive

**pomper** · 02-27-2015, 04:22 PM

Hello,

How can I remove duplicate rows and keep case sensitive rows
I have following rows:

row one
row One
row two
row two

and I want to keep

row one
row One
row two

I use Data -> Filter (Advanced) -> Filter the list, in place -> Unique records only but this is not case sensitive.

**M E Good @ XL4M** · 02-28-2015, 02:19 AM

Good morning London

Your list of texts to be evaluated in col A, then sort col A Ascending case sensitive selected.
B1 =IF(EXACT(A1,A2),"Delete","Keep",) copy down to match col A.
Filter on col B criteria "Delete" and delete filtered rows.

HTH

**bebo021999** · 02-28-2015, 02:59 AM

M E Good's solution failed if sorting is not allowed:
row one
row One
row two
row two
row One

for this case, use:

B1=A1

B2=IF(SUMPRODUCT(--EXACT(A2,$A$1:A1))=0,A2,"")

Drag B2 down

Filter B column then delete blank rows