State month based on Max value in a range

  • Thread starter Thread starter Dewayne
  • Start date Start date
D

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!
 
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!
 
Back
Top