Return a max value of a column

[kennyken]

Another day - another problem !!

I have 2 columns - the 1st with months (text format) and the secon
with numbers . What I want to happen is for excel to look at the 2n
column find the highest number (MAX formula ? ) and then return th
month from column A to which this maximum number which has been foun
corrosponds

Thank

 

[kkknie]

Try this:

=OFFSET(B3,MATCH(MAX(B3:B14),B3:B14)-1,-1)

Where in this example, the data (not the Month) is in B3:B14. Chang
it to the range you want changing every B3 and B14 to your max and mi
ranges.

 

[Dave Peterson]

You can also use =index():

=INDEX(A:A,MATCH(MIN(B:B),B:B,0))

 

[Dave Peterson]

And change my MIN() to MAX().

Oopsie!

Another day - another problem !!

I have 2 columns - the 1st with months (text format) and the second
with numbers . What I want to happen is for excel to look at the 2nd
column find the highest number (MAX formula ? ) and then return the
month from column A to which this maximum number which has been found
corrosponds

Thanks