sorting problem

[Yongguang.Qin]

I know sorting puts all true blank cells go to the bottom of the list.
My question is:
Is it possible to make blank cells caused by formulae such as
IF(logical_test,value_if_true,"") also do the same?

 

[Ken Johnson]

I know sorting puts all true blank cells go to the bottom of the list.
My question is:
Is it possible to make blank cells caused by formulae such as
IF(logical_test,value_if_true,"") also do the same?

One way is to sort the column in descending order first. This puts all
non-blanks at the top but in reverse order. Then select all the cells
from the top down to the last non-blank and sort in ascending order.

Ken Johnson