Sorting
 

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

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.)



Kev wrote:

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

--

Dave Peterson