In other words, you want to rank based on absolute values?

With your numbers in the range A1:A8...

Entered in B1 and copied down:

=SUMPRODUCT(--(ABS(A1)ABS(A$1:A$8)))+1

--
Biff
Microsoft Excel MVP


"Wicanucks" wrote in message
...
How can i rank numbers that are a variance of 100% when being over or
under
100% has the same score?

Example
-3.09%
6.04%
1.82%
1.46%
-4.14%
-0.73%
0.96%
4.60%

I want to rank the above numbers which are all a variance from 100% but
the
closest to 100% are the top ranked numbers. -.73 would be number 1 and
6.04%
would be number 8. 4.6 would be 7th and -4.14 would be 6th. Thanks