Forum Discussion
ExcelLearner2395
May 26, 2021Copper Contributor
Find max value in a data set but assign new value to result
Hi everyone, I'm using windows 10 and office 365. I was hoping you could help me to change the output of a max function. I'm trying to use a formula that would assign a value of 1/2/3 to the ...
mtarler
May 26, 2021Silver Contributor
you can use:
=MATCH(MAX(A1:A3),A1:A3,0)
=MATCH(MAX(A1:A3),A1:A3,0)