Sort Descending, zero and blanks at the bottom of the list

[lsteffen]

I am having trouble with a sort. I would like a list sorted descending, so that the highest dollar amount is at the top. However, if there are blanks or zeros in the list, it is putting those first. How do I get it to ignore them or put them at the bottom?

Thank you,
Liz

 

[Erdinç E. Karaçam]

Try this formula in the next column;

i.e.:
CELL: B1

=IF(OR(ISEMPTY(A1),A1=0),"","Sort")

And copy down

And, filter column B, By: Sort

And finally sort by desceding column A.

 

[lsteffen]

Thank you. This worked.

Liz

 

[Erdinç E. Karaçam]

Thank you. This worked.

Liz

You are welcome Liz.