sort with #DIV/0! at bottom

[psrs0810]

is there an easy way to sort information and leave #DIV/0! at the bottom?

Thanks

 

[Andrew Poulsom]

Isn't that what happens when you sort ascending?

 

[psrs0810]

true, but i need to sort desending

 

[Andrew Poulsom]

Then I think the answer is no.

 

[psrs0810]

what about changing the formula so that #DIV/0! does not show.
All I am calculating is A1/B1

 

[Andrew Poulsom]

You can suppress #DIV/0! with a formula like:

=IF(B2,A2/B2,"")

but the blanks will still appear at the top if you sort descending.

 

[psrs0810]

that will work - thanks