Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel |