How to identify duplicate data

[AV114]

I have a list of data that includes duplicates. I would like to find out only duplicates data

For example, I would like this:

Please Login or Register  to view this content.

...to become this:

Please Login or Register  to view this content.

Thanks!

[ImranBhatti]

Try this

Please Login or Register  to view this content.

[AV114]

but i have multiples cells to check , am not good in VBA .


For examples,

Please Login or Register  to view this content.

,

Could you please help me

[Sam Capricci]

here is a formula that should show duplicates ...
=IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","Ok")

[FDibbins]

Or you could use Conditional Formatting to check for (and color) duplicates

[AV114]

its work perfectly

[FDibbins]

its work perfectly

what does? Which option did you use?

[AV114]

=IF(COUNTIF($A$1:A1,A1)>1,"Duplicate","Ok")