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 ,
"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?

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: 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: 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 ,
"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?