How to return the text data of the first col after getting the max value from the 2nd col
Hi,
Does anyone have any suggestions on how to do the following?
I have 2 columns, one for months and the other for a number value.
I use the Max function to find the largest number in the second column,
which is 9 here.
My question: is there a function/formula that will return the cell
containing the word "May" based on the results of the Max function?
Jan 6 largest value is 9 for the month of May
Feb 2
Mar 4
Apr 2
May 9
June 3
Thanks.
|