Determining Duplicate numbers In A Column ?

[Robert11]

Hello:

Anyone have a link to a simple add-on that I can use to determine (easily)
if any numbers in a column are duplicates ?

Would like the duplicate numbers to be flagged as such; perhaps brought out
to a separate listing, or...

Thanks,
Bob

 

[Gord Dibben]

Chip Pearson has some formulas and methods to flag duplicates.

http://www.cpearson.com/excel/Duplicates.aspx

See also at the bootom of the page about "preventing duplicates"


Gord Dibben MS Excel MVP

 

[Traveller]

ASAP Utilities is a wonderful add-in (and FREE) and it does a great job
identifying duplicates. Go wo www.ASAP.COM.