Formula for Max Value and Row Name
I am trying to pull in the max value of column A and the name(s) associated with that value.
I am trying to use the following formula to pull in the max value and taking into consideration there could be multiples of the max value:
And then I would like to show the value(s) in column A that are tied to the maximum value. I was going to try a "Join" and "Collect" formula but didn't get very far.
Any assistance would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!