Sorting and Blank Cells

[Jeff G]

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.

 

[Pete_UK]

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