Max function

[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!

 

[Chip Pearson]

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)

 

[Peo Sjoblom]

Look at the large function

=LARGE(Range,2)

returns the second largest value

 

[Harlan Grove]

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.

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

Try LARGE(X,2)