Thread
:
Retuning a column number for a specific value
View Single Post
#
5
Harlan Grove
Posts: n/a
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)))
Reply With Quote