sorting with blank dates

[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?

 

[Dave Peterson]

Maybe you could add a helper column that can be sorted on:

=if(a2="","zzzzzz","aaaaaa")
and sort by that.

 

[comfuted]

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?

 

[Dave Peterson]

I haven't used xl2007's table feature enough to know.

Is that what you meant by table?