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)