Posted to microsoft.public.excel.misc
|
|
Ranking
Max,
it dun work. I believ only array can.
"Max" wrote:
How about using CF to highlight the top 3 within the range?
Assume source range in A1:E6
Select A1:E6 (A1 active), then apply cond formatting using Formula Is:
=MATCH(A1,LARGE($A$1:$E$6,COLUMN($A:$C)),0)
Format to taste, Ok out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Will" wrote:
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)
|