Re: unique filter results in some non-unique records.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi
See if Chip's site can help you:
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates
It's a fantastic resource.

AndyB

"Serials Librarian" <Serials Librarian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:EF779DD5-F7C5-41AB-B3D3-246B3ACF58C8@xxxxxxxxxxxxxxxx
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.


.

Relevant Pages

  • Re: Ron Rosenbaum on Dylans sarcasm
    ... Post Production A Tribute to Bob Dylan. ... She Belongs to Me: ... Don't Think Twice: ... Knockin' on Heaven's Door: ...
    (rec.music.dylan)
  • Re: Which is faster?
    ... cnb wrote: ... belongs to the same complexity-class but is still twice as slow no? ...
    (comp.lang.python)