Excel: Determining which argument to MAX() was the maximum -

is there way check argument in =max(1,3,2) maximum? example should return 2 (or 1 if index starts @ 0).

i have different sources of data , display 1 selected.

thanks! bernhard

you use:

=match(max(c37*2,b23*4,d4),choose({1,2,3},c37*2,b23*4,d4),0)

if 1 or more of 3 expressions being passed max in reality quite lengthy and/or resource-heavy, may worth avoiding repetition, e.g.:

=match(1,0/frequency(0,1/(1+choose({1,2,3},c37*2,b23*4,d4))))

though should note latter valid if results of 3 expressions being passed max non-negative.

regards