Finding duplicates VBA macro not working with numbers

[HelpExc]

This formula has to detects duplicates from column A and has to mark same duplicates with specific number in the next column

This formula is working for alphabetic words. I need it to work with number (phone numbers)

Please Login or Register  to view this content.

Workbook8.xlsx

[sktneer]

Does this work for you?

Please Login or Register  to view this content.

[stnkynts]

Duplicate post. You should stick to your original post.

http://www.excelforum.com/excel-prog...tes-macro.html