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