Sorting empty cells

I'm using Excel 2007.
I have a column that contains either "True" or is empty. I would like to sort it so that the empty cells are at the top.

I can't find any way to do it.

Nor can I.
But I can use a trick: fill the empty cells with a space, sort and delete those added spaces.

use a helper column that evaluates the cells and sort by the helper column

=if(a1,1,0)

Some explanation:

Booleans are not treated as text. They are rated larger than numbers, larger than text, and smaller than empty cells. True is larger than False

So, sort order is

1
2
3
a
b
c
FALSE
TRUE
<empty cell>

Try it.

teylyn;

Your order in the previous post seems to indicate that an empty cell would be sorted as greater than a boolean, so if I sorted in xlDescending order all the empty cells would be at the top. It didn't work.

But I like your idea of using a helper column better any way. Let's me decide whatever order I would like. I could create my own order if I want - 1,a,2,b,3,c etc.