sorting data that contains blanks
 

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!!!

sorting data that contains blanks
 

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!!!

sorting data that contains blanks
 

Thanks Joel. I guess I'll have to do that. I was hoping that the blanks
could be left in because the zeros make the report look sloppy.

"Joel" wrote:

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!!!