Prev: Chart - Custom Stacked Bar with Line
Next: Deleting rows meeting certain criteria in a particular column
From: Jason Sawyer on 1 Apr 2010 14:34
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.
From: Jason Sawyer on 8 Apr 2010 08:22
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'.
 | 
Pages: 1
Prev: Chart - Custom Stacked Bar with Line
Next: Deleting rows meeting certain criteria in a particular column