Max Value?

[Welsh Mark3]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Month[/TD]
[TD]Value[/TD]
[TD]Desired Result[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]20[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]20[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]50[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]150[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5[/TD]
[TD]150[/TD]
[/TR]
</tbody>[/TABLE]

I am treying to write a formula that finds the maximum value in a given mnmth. The table attempts to show what i am trying to do, the desired result is the value i am trying to produce.

 

[Fluff]

If you have MAXIFS, try
=MAXIFS($B$2:$B$7,$A$2:$A$7,A2)

otherwise
=MAX(IF($A$2:$A$7=A2,$B$2:$B$7))
This needs to be confirmed with Ctrl Shift Enter, rather than just Enter

 

[Welsh Mark3]

=MAX(IF($A$2:$A$7=A2,$B$2:$B$7)) seems to give me the largest value from the entire range but not for each month.
I have used the fill down function to drage the formula down, Do I need to try something? And again I appreciate your help

 

[Fluff]

Did you confirm it with Ctrl Shift Enter?
If so you shold see the formula wrapped in {}

 

[Welsh Mark3]

Do I need to select the entire array of cells and simply select Ctrl Shift Enter? I do not see the fomula wrapped

 

[Fluff]

Select the first cell the formula is in, press F2, then Ctrl Shift Enter, then drag the formula down.

 

[Welsh Mark3]

Works perfeectly thank you

 

[Fluff]

You're welcome & thanks for the feedback