Filter for Unique Values not working

  • Thread starter Thread starter Joe M.
  • Start date Start date
J

Joe M.

I've used this before but now it isn't working. When I try to use the
advanced filter to return a column of unique values, it returns the same list
which includes multiple of the same values. It doesn't matter if I select to
filter in place or copy to another location. I made sure unique values was
checked. I tried it several times. Can anyone help please?
Thanks,
Joe M.
 
Perhaps it's extraneous white spaces (especially hard to see "trailing"
spaces) messing things up.

Try TRIM on your original data col, then run unique filter again

Eg: If your data is in A1 down, put in B1: =TRIM(A1). Copy down to the last
row of data. Then copy col B, overwrite col A with a paste special as values.
Clear col B. Then run unique filter on col A - see what you get this time as
the results
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adv Filter - Unique Items NOT working 6
Filter (blanks) with two or more unique values not working 1
unique records by advanced filter 10
Excel 2002: Advance filter -How to select table with unique refere 4
Filtering with SUMIFS 1
Filtering for Unique Records with multiple-column criteria 5
Filtering without redundancies 2
Filer for unique records and return all column data for unique rec 1

Back
Top