View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

bj wrote...
....
note if there can be several equal maxs this won't work.

in this case try
=match(max(range),range,0)+(column number at start of range)-1

....

Or

=COLUMN(INDEX(range,MATCH(MAX(range),range,0)))