=LARGE(B11:J11,{1,2,3,4,5}) array entered in five cells

Adjust the range to suit your requirements.

Regards

Trevor


"Master" wrote in message
...
Hi everyone!

How do i get the top 5 numbers in a range of cells?

example:

A B C
100
25
34
65
87
12
10
99

I was already able to get the highest number using the max function.
=max(a1:a8)
In another set of cells i want the formula to return the value of the 2nd
to
the highest and so on and so forth.

Thanks for the help.