May 26 2021 11:55 AM
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 ouput depending on if the highest value is in column A/B/C. For example:
967 | 616 | 599 | 1 |
440 | 507 | 200 | 2 |
271 | 193 | 491 | 3 |
494 | 534 | 291 | 2 |
Where the final column would have the formula creating the results of the max from the 3 others.
I hope this somewhat makes sense.
Thanks for any help!
May 26 2021 12:05 PM
=XMATCH(MAX(range),range))
May 26 2021 12:05 PM
May 26 2021 01:11 PM
May 26 2021 02:03 PM
Nice, it's so easy to forget the MAX/MIN capabilities of XMATCH and its elder sibling XLOOKUP.
May 26 2021 02:28 PM
May 27 2021 06:03 AM
@mtarler , good point