sorting problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yongguang.Qin@gmail.com - 15 Oct 2007 21:03 GMT

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?

Reply to this Message

Ken Johnson - 15 Oct 2007 22:13 GMT

On Oct 16, 6:03 am, Yongguang....@gmail.com wrote:

> 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

Reply to this Message