Function to find the second largest number in a series of numbers

J

john4938

I have the function that finds the largest number in a series o
numbers....but I want to find the second largest number in the series.
What is the function?

Thanks...
 
P

Paul

john4938 said:
I have the function that finds the largest number in a series of
numbers....but I want to find the second largest number in the series.
What is the function?
Click to expand...

LARGE
For example,
=LARGE(A1:A10,2)
will find the second largest value in A1:A10.
 

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

Help. Trying to do the opposite of VLOOKUP 3
Find values across a row and return a text value from the same column 3
Return Column Header from an Index/array, finding Large with a userinput date 0
using an IF or AND function to get next largest value in list 1
Find Smallest and Largest. 5
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Automatic Sorting? 6
Lookup function to return highest value 4

Top