Filter (blanks) with two or more unique values not working

[Jason Sawyer]

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.

 

[Jason Sawyer]

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