Case Sensitive Duplicate Values

[ruthit]

Hi everyone!

Does anyone know how to find case sensitive duplicate values (0001678bv5 and 0001678bV5 are NOT duplicates) in Excel? I don't want to delete these values, I only want them highlighted. I found a formula to input in the conditional formatting tool, but I must be missing something because it is not working. This is the formula: =AND(A2<>"""",SUMPRODUCT(--(EXACT(A2,$A$2:$A$13000)))>1)" where A2:A13000 is the column in which I need to find these duplicate values.

Please help!

 

[Mike LH]

Hi,

Try this CF formula.

=AND(A2<>"",SUMPRODUCT(--(EXACT(A2,$A$2:$A$13000)))>1)

 

[ruthit]

Hi Mike LH, Thanks so much for responding, but this formula does not work. I'm open to trying any other ways...