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


J

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

Advertisements

J

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

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

Top