RE: extra results in the MAX function
- From: "Peo Sjoblom" <PeoSjoblom@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 18 May 2005 09:45:25 -0700
=INDEX(A2:A5,MATCH(MAX(B2:B5),B2:B5,0))
where A holds the months and B the amounts
note that if the are more than one max value the first occurrence will be
retrurned
Regards,
Peo Sjoblom
"jeroen" wrote:
> I am trying to maximize a column in excel. I want to get netxt to that result
> the month in in wich this maximum turnover has been achieved
>
> january 50.000
> february 60.000
> march 70.000
>
> I know how to use the max function, but I do not want just as a result
> 70.000, but I want to see next to it that this result comes from the month
> march.
> Please help
> --
> jeroen
.
- Follow-Ups:
- RE: extra results in the MAX function
- From: jeroen
- RE: extra results in the MAX function
- References:
- extra results in the MAX function
- From: jeroen
- extra results in the MAX function
- Prev by Date: Re: Help with a hide row macro (not using filter)
- Next by Date: i want to create a simple mailing list can u help
- Previous by thread: extra results in the MAX function
- Next by thread: RE: extra results in the MAX function
- Index(es):
Relevant Pages
|
