Sorting

K

Kev

Is it possible when you have cells with formulas in to sort them so all blank
cells appear at the bottom.

I know it does this automatically when there are no formulas, but when there
are it places them at the top.

Thanks


kevin
 
D

Dave Peterson

I'd use a helper cell and formulas like:

=if(b2<>"",b2,rept("z",9999))

Then sort by that column.

(Use a string that sorts to the bottom of your data.)
 
Top