MAX
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.
|