View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wicanucks Wicanucks is offline
external usenet poster
 
Posts: 1
Default Ranking numbers that are a variance of 100%

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