Thread
:
Ranking
View Single Post
#
1
Posted to microsoft.public.excel.misc
Will
external usenet poster
Posts: 129
Ranking
With ref to the below table:
a b c d e
A 1 5 6 8 2
B 6 9 10 11 12
C 9 8 7 7 4
D 1 2 3 4 19
E 13 14 15 20 5
F 6 7 8 9 10
Which formula shd I use if I need to rank them according to col & row:
Largest: (E, d)
2nd : (D, e)
3rd : (E, c)
Reply With Quote
Will
View Public Profile
Find all posts by Will