How do I search for the second largest value in the array?
in [Functions]
|
Prev: Conditional format will not work without $ (removed to allow c
Next: Reference different lines in the same cell
From: Golf on 22 Apr 2010 03:37 How do I search for the second (or third and so on) largest value in the array either in column or row?
From: "David Biddulph" groups [at] on 22 Apr 2010 03:58 =LARGE(A:A,2) =LARGE(A:A,3) =LARGE(1:1,2) =LARGE(1:1,3) -- David Biddulph "Golf" <Golf(a)discussions.microsoft.com> wrote in message news:241155EE-30CA-4E7C-8E8C-2215F1523919(a)microsoft.com... > How do I search for the second (or third and so on) largest value in the > array either in column or row?
From: Ms-Exl-Learner on 22 Apr 2010 04:33
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? |