sorting with blank dates

  • Thread starter Thread starter comfuted
  • Start date Start date
C

comfuted

I would like to sort a table of tasks by completed date, with the completed
ones a the bottom where I don't see them. Default is to put blanks at the
bottom. I am sorting on multiple columns, not just this one. Is there a way
to do it?
 
Maybe you could add a helper column that can be sorted on:

=if(a2="","zzzzzz","aaaaaa")
and sort by that.
 
Dave:
Thanks, that worked fine. But when I did it, something funny happened. I put
the formula in the top cell of the column and then hit Enter, and it filled
in the whole column (to the proper row) with the formula and incorporated
that column into the table which was made up of all the columns to the left.
Maybe that is something that happens automatically with tables?
 
I haven't used xl2007's table feature enough to know.

Is that what you meant by table?
 
Back
Top