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

[Guest]

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?

 

[JE McGimpsey]

One way:

=LARGE(A:A,2)

 

[Kevin H. Stecyk]

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 A11 you'd use:
=large(A11,2).

----------

Hope this helps.

Kevin

Keith wrote...

 

[Guest]

Thank you very much!!

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 A11 you'd use:
=large(A11,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?

 

[Guest]

Thank you very much!

One way:

=LARGE(A:A,2)