Put something else in the column besides a blank. A simple method is to
modify you formula and put 0 instead of a blank in these cells.

"William" wrote:

I have a spreadsheet that has a column containing results from a formula. In
these
columns, about half of the cells are blanks, resulting from the formula. I
sort the columns "Z-A" trying to get the highest value at the top. The
blanks are placed at the very top, as if they are the highest value. How can
I get the blanks to be considered as the smallest values and
being placed at the bottom. Thanks!!!