How do I get MAX, MAX -1, MAX -2

  • Thread starter Thread starter pilzner
  • Start date Start date
P

pilzner

I have a list of numbers that I need the MAX number for......so far
that's easy, but I also need MAX -1 and MAX -2.

In other words I need the 3 greatest numbers in the list.

I DO NOT want to sort.

I need this as a formula.

Thanks in advance for your help

-P
 
Check out the LARGE() function.

LARGE(A1:Z1,1) gives the largest number in the range
LARGE(A1:Z1,2) gives the second largest
etc.
 
You must log in or register to reply here.

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

Max If 1
Max; Min & Dates 2
max and min help. 5
Max only if the last month is hte highest 4
Conditional MAX 4
MATCH with MAX formula question 5
Index of Max Cell 7
Subtract Min() from MAX() 2

Back
Top