Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter for Unique Values not working
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter for Unique Values not working
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Joe M." wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count unique values & filter | Excel Worksheet Functions | |||
Unique Records Only is not working.... | Excel Worksheet Functions | |||
unique filter results in some non-unique records. | Excel Discussion (Misc queries) | |||
Unique Value without using FILTER | Excel Worksheet Functions | |||
Count unique values and create list based on these values | Excel Worksheet Functions |