2nd to MAX

[Danny]

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.

[Peo Sjoblom]

=LARGE(Range,2)

=SMALL(Range,2)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Danny" <Danny@discussions.microsoft.com> wrote in message
news:62E12F90-8753-4D43-88DF-E32BEA346572@microsoft.com...
> 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.

[Danny]

Thanks a lot Peo. Have a great day!

"Peo Sjoblom" wrote:

> =LARGE(Range,2)
>
> =SMALL(Range,2)
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
> "Danny" <Danny@discussions.microsoft.com> wrote in message
> news:62E12F90-8753-4D43-88DF-E32BEA346572@microsoft.com...
> > 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.
>
>
>