Max function

  • Thread starter Thread starter Rod Davis
  • Start date Start date
R

Rod Davis

I have no problem usingthe Max function to locate the
highest value in a row, but I need to be able to extract
the highest AND next-to-highest vale from a row.

Does anyone have any ideas please? Thank you!
 
Rod,

Use the LARGE function. E.g.,

=LARGE(A1:A10,2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
I have no problem usingthe Max function to locate the
highest value in a row, but I need to be able to extract
the highest AND next-to-highest vale from a row.
Click to expand...

MAX(X) == LARGE(X,1)

Try LARGE(X,2)
 
Back
Top