Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate variance between numbers? | Excel Worksheet Functions | |||
Editing a column chart for Variance Walk negative numbers | Charts and Charting in Excel | |||
how do i display a variance in all positive numbers? | Excel Worksheet Functions | |||
Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |