| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
unique filter results in some non-unique records.
I have a list of ISSN (journal) numbers in one column, some are repeated
twice, some three times, and some are only there once. I copy this list, choose an advanced filter to copy to another location, and click 'unique records only'. The result is that some numbers are truly unique, and some are not. My list is long, 8963 cells, and I have checked it to see if there are spaces, etc. My column also includes colour. Does colour affect how 'unique' is defined? Is my list too long? I need to keep the colour, because this is the way that I know which original list each number belongs to. Any help with this is appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unique filter results in some non-unique records.
Hi
See if Chip's site can help you: http://www.cpearson.com/excel/duplic...tingDuplicates It's a fantastic resource. AndyB "Serials Librarian" <Serials wrote in message ... I have a list of ISSN (journal) numbers in one column, some are repeated twice, some three times, and some are only there once. I copy this list, choose an advanced filter to copy to another location, and click 'unique records only'. The result is that some numbers are truly unique, and some are not. My list is long, 8963 cells, and I have checked it to see if there are spaces, etc. My column also includes colour. Does colour affect how 'unique' is defined? Is my list too long? I need to keep the colour, because this is the way that I know which original list each number belongs to. Any help with this is appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
unique filter results in some non-unique records.
How did you check for spaces? Run this macro first, then do the filter
http://www.mvps.org/dmcritchie/excel/join.htm#trimall Regards, Peo Sjoblom "Serials Librarian" wrote: I have a list of ISSN (journal) numbers in one column, some are repeated twice, some three times, and some are only there once. I copy this list, choose an advanced filter to copy to another location, and click 'unique records only'. The result is that some numbers are truly unique, and some are not. My list is long, 8963 cells, and I have checked it to see if there are spaces, etc. My column also includes colour. Does colour affect how 'unique' is defined? Is my list too long? I need to keep the colour, because this is the way that I know which original list each number belongs to. Any help with this is appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I set the status bar to count results from filter? | Setting up and Configuration of Excel | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| How do I get the filter results to show up in the status bar? | Excel Discussion (Misc queries) | |||
| multiple results when using filter function | Excel Worksheet Functions | |||
| Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
Hybrid Mode
