Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter (blanks) with two or more unique values not working
Excel 07 - Multiple workbook issue - One of them has 6540 rows and CA
columns. I auto filter all headers then try to sort on column BM (or any). I can filter for (blanks) and one unique value and will see only those items. If I choose (blanks) and two or more unique values, I will see all of the selected items but no (blanks). Column BM has eight unique values and (blanks). I have tried selecting all the data before setting my filter, exporting to tab delimited text file then importing into a new workbook, changing the format of the cells to text/general/number. So far nothing will allow me to have (blanks) with more than one unique value in my filter. Is this something that cannot be performed or am I just an id10t or both? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter (blanks) with two or more unique values not working
As it turns out, the "blanks" were not actually blanks. There was a space in
each cell. I removed the space and it works perfect. So it seems that I must go with 'I'm an idiot'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count unique values with auto-filter on | Excel Worksheet Functions | |||
Adv Filter - Unique Items NOT working | Excel Discussion (Misc queries) | |||
Filter Unique Values | Excel Worksheet Functions | |||
Filter for Unique Values not working | Excel Discussion (Misc queries) | |||
count unique values & filter | Excel Worksheet Functions |