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.