Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |