Locating a cell address

  • Thread starter Thread starter MikeB
  • Start date Start date
M

MikeB

Let's say I have a table:

Month Usage
Jan 10
Feb 12
Mar 14
Apr 16
May 14
Jun 18
Jul 12
Aug 8

etc.

If I use the "Max" function to obtain the value for Jun, is there some
way that I can obtain the corresponding value for the cell containing
"Jun", so I can have a summary as follows:

Max: 18 (Jun).

Hope that's clear.

Thanks.
 
With months in A2 to A9, and values in B2 to B9, try this:

=INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0))

If you have duplicate max values, this formula will return the month of the
*first* max value.
 
Back
Top