How do I search for the second largest value in the array?

G

Golf

How do I search for the second (or third and so on) largest value in the
array either in column or row?
 
M

Ms-Exl-Learner

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using an IF or AND function to get next largest value in list 1
How to get largest date from a Vlookup 1
Automatic Sorting? 6
Treating multiple paragraphs as one 2
How to clear prior search terms from Navigation Pane 0
Finding the largest match 9
Reference to the N-largest value in an array 4
Return Column Header from an Index/array, finding Large with a userinput date 0

Top