If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I search for the second largest value in the array?
How do I search for the second (or third and so on) largest value in the
array either in column or row? |
#2
|
|||
|
|||
How do I search for the second largest value in the array?
=LARGE(A:A,2)
=LARGE(A:A,3) =LARGE(1:1,2) =LARGE(1:1,3) -- David Biddulph "Golf" wrote in message ... How do I search for the second (or third and so on) largest value in the array either in column or row? |
#3
|
|||
|
|||
How do I search for the second largest value in the array?
Assume that you would like to get the result from A column Data.
Column:- This will get the Largest number from A Column =LARGE(A:A,1) Similar to =MAX(A:A) But when you would like to get the second largest number then change the 1 to 2 in the above large formula like the below =LARGE(A:A,2) Assume that you would like to get the result from 1st Row Data. Row:- =LARGE(1:1,1) =LARGE(1:1,2) Column:- This will get the Smallest number from A Column =SMALL(A:A,1) Similar to =MIN(A:A) But when you would like to get the second Smallest number then change the 1 to 2 in the above Small formula like the below =SMALL(A:A,2) Assume that you would like to get the result from 1st Row Data. Row:- =SMALL(1:1,1) =SMALL(1:1,2) -- Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Golf" wrote: How do I search for the second (or third and so on) largest value in the array either in column or row? |
Thread Tools | |
Display Modes | |
|
|