How to identify duplicates between very long numbers

[armor1]

Hi all
I have created a macro that highlights a cell if value is a duplicate within same column (talking just about column C). It runs based on countif function.
Unfortunately this doesn't work for very long numbers (those that are longer than 15 digits), neither Conditional formatting works.

Is there a way to validate such long numbers (I mean identify duplicates)? I've found out that CTRL+F is able to identify very long number as unique even if Conditional formatting and My macro are not able to (so it can say how many instances of value exist withing column).

Thanks for your help

[AB33]

Assuming you are running on sheet 1 column C and the non duplicate will be in column D. The code will only lists unique cellls.

Please Login or Register  to view this content.

[stnkynts]

edit: ninja'd by AB33

[AB33]

stnkynts,
I am sure it is not the same code as mine and would love to see your code.

[armor1]

I am sorry, I am not that good in VBA, but seems that macro you have suggested doesn't work either. I'd like to see cells that are duplicated within column C highlighted and with comment. I know your macro works differently, but doesn't say properly which value is duplicate and which is not