State month based on Max value in a range

[Dewayne]

I have a worksheet that returns the maximum value within 1
row range, i.e. Jan - Dec.
Is there a way to return the name of the month in which
the maximum value occurs in another cell?
Thank you!

 

[RagDyer]

Headers Jan to Dec in B1:M1
Labels A2:A100
Values in B2:M100

Enter this in N2, and copy down:

=INDEX($B$1:$M$1,MATCH(MAX(B2:M2),B2:M2,0))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have a worksheet that returns the maximum value within 1
row range, i.e. Jan - Dec.
Is there a way to return the name of the month in which
the maximum value occurs in another cell?
Thank you!