'advanced filter/unique values only' inaccurate counts

  • Thread starter Thread starter wurd
  • Start date Start date
W

wurd

i often have to use filters to reduce a column of numbers to just it's
unique values. simple enough, but unfortunately excel's advanced
filter doesn't always do the job and leaves out values or just doesn't
filter correctly. i'm hoping there's a simple explanation for this and
the filter can be made more reliable. any thoughts?
 
The filters are reliable, so there may be a problem with the data. For
example, a space at the end of a text string can cause two cells that
look the same to be extracted by the filter.

Perhaps you can give an example of what's left out, or how it's not
filtering correctly.
 
Back
Top