View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William William is offline
external usenet poster
 
Posts: 119
Default 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!!!