Top 3 (MAX function variant)

[Shane O]

Is there a way (preferably not using VBA) to determine the highest 5 records in a single row or column?

example:

A: 1200
B: 1250
C: 1100
D: 1800
E: 1500
F: 1100
G: 1200
H: 800

the top 5 would be (in order): 1800, 1500, 1250, 1200, 1200

[shg]

=large(a1:h1, 1)
=large(a1:h1, 2)
...
=large(a1:h1, 5)

[Shane O]

lol, lots simpler than I thought it would be.


Thanks a lot for your help!