Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what function do I use for excel to choose the 2nd highest number
I want excel to determine the 2nd and 3rd highest numbers from a list of
numbers. What function do I use? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what function do I use for excel to choose the 2nd highest number
check out large() in help
"ematboy" wrote: I want excel to determine the 2nd and 3rd highest numbers from a list of numbers. What function do I use? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what function do I use for excel to choose the 2nd highest number
Hi
=LARGE($A$1:$A$100,ROW(A1)) will find the largest number in the range A1:A100 as you copy down, ROW(A1) will become ROW(A2). and find the 2nd largest , then the 3rd largest etc. -- Regards Roger Govier "ematboy" wrote in message ... I want excel to determine the 2nd and 3rd highest numbers from a list of numbers. What function do I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
which function to choose? | Excel Worksheet Functions | |||
Which function to choose? | Excel Worksheet Functions | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
Excel Formula - to calculate highest number from a set of numbers | Excel Worksheet Functions | |||
In Excel, I need to now how to pick the second highest number in . | Excel Worksheet Functions |