sorting problem

  • Thread starter Thread starter Yongguang.Qin
  • Start date Start date
Y

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?
 
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?
Click to expand...

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
 
Back
Top