View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
NDBC NDBC is offline
external usenet poster
 
Posts: 204
Default 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