sorting data that contains blanks

  • Thread starter Thread starter William
  • Start date Start date
W

William

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!!!
 
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.
 
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.
 
Back
Top