formula to find second (third, etc.) largest number in a list

M

MSJ

Operating System: Mac OS X 10.6 (Snow Leopard) What is the formula to find the second largest number in a list? MAX worked fine to find the largest number, need help to find next to the largest number. I'm sure this is easy (but not for me).
 
C

Carl Witthoft

Operating System: Mac OS X 10.6 (Snow Leopard)

What is the formula to find the second largest number in a list? MAX worked
fine to find the largest number, need help to find next to the largest
number. I'm sure this is easy (but not for me).
Click to expand...

LARGE()
 

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

Find values across a row and return a text value from the same column 3
Return value to right of LARGE() 2
need help creating formula in excel 6
View Excel Cell Location 4
subtraction formula 4
Averaging columns with missing numbers 3
Zero values 2
using an IF or AND function to get next largest value in list 1

Top