finding the cell adjacent to the max value in a row with formula
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
|