Okay, I got that and thankyou! Now how to I use this to have two
worksheets.. I need to find the max of PM Kinder and Am Kinder. (I don't
want the max of each class, but the max of the two classes if I combined
them) Lets say the cell range is the same for both sheets. I found that I
could do this for two pages without the Index, but when I put the Inder in it
just errors out. Am I asking the impossible?

"Leith Ross" wrote:


Hello rmwarde,

You got the post with the typo. I corrected it shortly after it was
posted. The formula should be...

=OFFSET('PM Kinder'!A5, MATCH(MAX('PM Kinder'!A5:A19), 'PM
Kinder'!A5:A19,0) - 1, -1, 1, 1)

My apologies,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=492431