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

M

Master

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MAX 4
Finding location (or start cell) of highest consecutive values 3
Trying to find additional ranges outside of min, max, and average 2
Finding the proper style field and the numbered paragraph value within the style 0
Number range as a percentage 2
Multiple formats in one cell 1
Compare last digit in 5 cells for match 0
*Issue* Concatenate dates in a large range of cells in a row. 5

Top