How to return the text data of the first col after getting the max value from the 2nd col

J

Joyce

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.
 
D

David Billigmeier

Assume your month names are in column A, and your numbers are in column B:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))

Just change the row and column references to fit your data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
How to getting text labels to show up in scatter chart. 0
Finding the right style field in VBA 0
Lookup function to return highest value 4
Return Column Header from an Index/array, finding Large with a userinput date 0
Look for Max and second Max 0
Cumulative sum, based on previous data 0
How can the font and size of (all) citation numbers be altered? 1

Top