ranking a set of values in Excel
Posted on 2014-12-01
I have a spreadsheet where cells, says A1 B1 C1 .....XX1 contains numerical values which are the result of some calculation
I want to have cells A2 B2 C2 ... XX2 containing the ranking (descending values) of corresponding values A1 B1 C1 ... XX1
For example with 5 cells A1 B1 C1 D1 E1 containing 12 23 98 33 10, cells A2 B2 C2 D2 D2 should contain 4 3 1 2 5
Is there a formula to calculate that ?