| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i get the top 5 numbers in a range of cells?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| How do i get the top 5 numbers in a range of cells? | Excel Worksheet Functions | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
| How do I create formula to count numbers in a range of cells? | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Threaded Mode
