String comparison

I have used a formula to concatenate two fields. I now need to go through and see if there are any duplicates. There are 2078 rows so I do not want to do this manually.

Any help would be appreciated,

Dan

Hi,

I would recommend in the column next to your data to have

Please Login or Register  to view this content.

and copy all the way ... to Tag all your duplicates ...

HTH
Carim

Good afternoon HurricaneDan

Welcome to the forum!

Go to the first cell in yoiur range where you have duplicates.
Go to Format > Conditional Formatting
Set to FormulaIs and enter this formula :

=IF(COUNTIF($A$1:$A$100, A1)>1,TRUE,FALSE)

Where A1 is the first cell of the range you wish to check and A1:A100 is the relevant range. Select your formatting and click OK.
Use format painter to copy it to the end of the range. This will highlight all duplicates - NOT subsequent duplicates.

HTH

DominicB

Thank you both for your help. This is exactly what I was looking for!

Thanks again,

Dan

We are both happy to hear your problem's fixed ...

Thanks for the feedback

Carim