|
In response to
"LIR ... MS Excel 2007 help needed. how do i sort cells in columns so ..."
by
reluctantcynic (en treo)
|
I answered you on b2, but here:
Posted by
JaxSean (aka JaxSean)
Feb 17 '09, 07:50
|
You'd have to sort by another column first - Excel won't sort blank cells on their own.
or you could create a new column next to the column you want to sort, and put a function in it like:
=IF(a1 = "", 0, 1)
which is basically saying if there's no data in the cell, make the new column cell a 0, if there is data, put a 1.
Then sort by the new column ascending (so your 0's show up top).
|