Filter for Unique Values not working

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.
 
M

Max

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
Return Unique Records ... No Blanks 4
Unique values within a list 3
Unique Values, not Unique Records 1
delete records with unique value 1
Create List of Unique Values from several columns 2

Top