In Excel, I need to now how to pick the second highest number in .

I am attempting to do inventory analsysis where I need to pick the highest
and second highest values from a row of numbers. I can get the highest by
using the MAX function....how do I get the second highest number?

One way:

=LARGE(A:A,2)

In article <[email protected]>,
"Keith" <[email protected]> wrote:

> I am attempting to do inventory analsysis where I need to pick the highest
> and second highest values from a row of numbers. I can get the highest by
> using the MAX function....how do I get the second highest number?

Hi Keith,

I found this solution in Google archives.

Chris Nelson Sep 14 1997, 12:00 am
Newsgroups: microsoft.public.excel.programming
From: "Chris Nelson"
Date: 1997/09/14
Subject: Re: Excel formula problem - Help!


The function you seek is LARGE([range],[rank]). So to find the
second largest value in A1:D1 you'd use:
=large(A1:D1,2).

----------

Hope this helps.

Kevin

Keith wrote...
>I am attempting to do inventory analsysis where I need to pick the highest
> and second highest values from a row of numbers. I can get the highest by
> using the MAX function....how do I get the second highest number?

Thank you very much!!

"Kevin H. Stecyk" wrote:

> Hi Keith,
>
> I found this solution in Google archives.
>
> Chris Nelson Sep 14 1997, 12:00 am
> Newsgroups: microsoft.public.excel.programming
> From: "Chris Nelson"
> Date: 1997/09/14
> Subject: Re: Excel formula problem - Help!
>
>
> The function you seek is LARGE([range],[rank]). So to find the
> second largest value in A1:D1 you'd use:
> =large(A1:D1,2).
>
> ----------
>
> Hope this helps.
>
> Kevin
>
> Keith wrote...
> >I am attempting to do inventory analsysis where I need to pick the highest
> > and second highest values from a row of numbers. I can get the highest by
> > using the MAX function....how do I get the second highest number?
>
>
>

Thank you very much!

"JE McGimpsey" wrote:

> One way:
>
> =LARGE(A:A,2)
>
> In article <[email protected]>,
> "Keith" <[email protected]> wrote:
>
> > I am attempting to do inventory analsysis where I need to pick the highest
> > and second highest values from a row of numbers. I can get the highest by
> > using the MAX function....how do I get the second highest number?
>