You could use a helper column and put this formula in it:

=ABS(A1)

and copy this down - assume it is in column B. Then you could apply
the rank formula like this:

=RANK(B1,B$1:B$10,1)

and copy this down.

Hope this helps.

Pete

On Oct 16, 4:50*pm, "Terry Bennett" wrote:
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.