perhaps
=INDEX(L5:IV5,,MATCH(MAX(L5:IV5),L5:IV5,0)-1)

NDBC;436736 Wrote:
I think I can find the column of the max value in a row using

=column(max(L5:iv5))

is there a way to select the value in the cell immediately to the left
of
this cell, so column-1.

Thanks


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121229