Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2nd to MAX
Hi,
Please help me with a formula to get the SECOND highest number. 1, 3, 5, 7, 9 If I use the max worksheet function using the above numbers, I get 9. What formula will I use to get "7" Please include another formula for second to the MIN function. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2nd to MAX
=LARGE(Range,2)
=SMALL(Range,2) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Danny" wrote in message ... Hi, Please help me with a formula to get the SECOND highest number. 1, 3, 5, 7, 9 If I use the max worksheet function using the above numbers, I get 9. What formula will I use to get "7" Please include another formula for second to the MIN function. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
2nd to MAX
Thanks a lot Peo. Have a great day!
"Peo Sjoblom" wrote: =LARGE(Range,2) =SMALL(Range,2) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Danny" wrote in message ... Hi, Please help me with a formula to get the SECOND highest number. 1, 3, 5, 7, 9 If I use the max worksheet function using the above numbers, I get 9. What formula will I use to get "7" Please include another formula for second to the MIN function. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|