Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |