Filter for duplicates
 

I have a list of supposedly unique 11 digit numbers (the list is approaching
100,000 numbers). I need to check through for duplicates. Is there any way
to do this in Excel, other than the Advanced Filter, copying to another
location with 'unique records only' checked?

If not Excel, then in Access?

Thanks,

Richard

Filter for duplicates
 

Chip has lots about duplicates. See www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rich" wrote in message
...
I have a list of supposedly unique 11 digit numbers (the list is
approaching
100,000 numbers). I need to check through for duplicates. Is there any
way
to do this in Excel, other than the Advanced Filter, copying to another
location with 'unique records only' checked?

If not Excel, then in Access?

Thanks,

Richard