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.

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.

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.