I'm sure there is an easy way of doing this ...

I have a list of data values that I want to rank in terms of the
nearest/furthest away from zero. Some of the values are positive and some
are negative.

How do I use RANK such that No 1 is the value (positive or negative) that is
nearest to zero, No 2 is next nearest, etc?

Many thanks.