G
Guest
I have a column which has a formula in each cell pulling data from a second
worksheet. If the cell does not find data in the second worksheet, then a
blank ("") is entered into the cell.
The problem is that I would like the sort ascending the data after it
updates from the second worksheet, but if there are blank cells then they are
placed at the top of my column. I thought that Excel always put blank cells
at the bottom of a sort ascending. Does the formula in the cell make it a
"nonblank" cell?
Thanks.
worksheet. If the cell does not find data in the second worksheet, then a
blank ("") is entered into the cell.
The problem is that I would like the sort ascending the data after it
updates from the second worksheet, but if there are blank cells then they are
placed at the top of my column. I thought that Excel always put blank cells
at the bottom of a sort ascending. Does the formula in the cell make it a
"nonblank" cell?
Thanks.