Thread: MAX
View Single Post
  #1   Report Post  
Master
 
Posts: n/a
Default 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.