Max Value?

[Welsh Mark3]

Month	Value	Desired Result
1	10	20
1	20	20
2	20	50
2	50	50
3	150	150
3	5	150

<tbody>
</tbody>

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