Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
Use
match( max( augment( A, B, C)), augment( A, B, C))
And inspect the vector of results.
Update:
See attachment
Success!
Luc
Hi,
I was curious and tried Luc's solution.
You may also omit the "augment" function in "max" when using Luc's solution.
Depending on which way you need the result, you may turn it into a function.
Unfortunately there is no way we could automatically access the name of a variable.
Prime 10 sheet attached