Locating a cell address

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeB - 02 Sep 2007 08:06 GMT

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.

Reply to this Message

Ragdyer - 02 Sep 2007 08:20 GMT

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.

Signature

HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> Let's say I have a table:
>
[quoted text clipped - 19 lines]
>
> Thanks.

Reply to this Message