Something like this can't be done??????????:

=OFFSET(Max(B7:E7),-1,0,1,1

--
John2
-----------------------------------------------------------------------
John21's Profile: http://www.excelforum.com/member.php...fo&userid=3698
View this thread: http://www.excelforum.com/showthread.php?threadid=57379