software

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 quot;7quot;

Please include another formula for second to the MIN function.

Thank you.

=LARGE(Range,2)

=SMALL(Range,2)--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Dannyquot; gt; wrote in message
...
gt; Hi,
gt;
gt; Please help me with a formula to get the SECOND highest number.
gt;
gt; 1, 3, 5, 7, 9
gt;
gt; If I use the max worksheet function using the above numbers, I get 9.
gt; What formula will I use to get quot;7quot;
gt;
gt; Please include another formula for second to the MIN function.
gt;
gt; Thank you.
Thanks a lot Peo. Have a great day!

quot;Peo Sjoblomquot; wrote:

gt; =LARGE(Range,2)
gt;
gt; =SMALL(Range,2)
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;Dannyquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; Please help me with a formula to get the SECOND highest number.
gt; gt;
gt; gt; 1, 3, 5, 7, 9
gt; gt;
gt; gt; If I use the max worksheet function using the above numbers, I get 9.
gt; gt; What formula will I use to get quot;7quot;
gt; gt;
gt; gt; Please include another formula for second to the MIN function.
gt; gt;
gt; gt; Thank you.
gt;
gt;
gt;