Sorting and Blank Cells
 

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.

Sorting and Blank Cells
 

Yes, Jeff, that is correct. If you want them to sort to the bottom,
perhaps you could amend your formulae to return "zz_Not found" instead
of "".

Hope this helps.

Pete

On Jan 26, 7:43 pm, Jeff G wrote:
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.