sorting with blank dates
 

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?

sorting with blank dates
 

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

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

comfuted wrote:

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

sorting with blank dates
 

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" wrote:

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

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

comfuted wrote:

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

sorting with blank dates
 

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

Is that what you meant by table?

comfuted wrote:

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" wrote:

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

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

comfuted wrote:

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


--

Dave Peterson