Is this possible, function to read list and return largest value?

[dooder]

So here is what I am trying to achieve

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Person[/TD]
[TD="width: 64"]Case#[/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]17[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]18[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]Doug[/TD]
[TD]17[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Doug[/TD]
[TD]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Doug[/TD]
[TD]19[/TD]
[TD]Y[/TD]
[/TR]
</tbody>[/TABLE]


I want the third col to "trigger" with a "Y" when col B is the highest value for the variable in col A. I'm playing around with countif functions, and maybe search functions, but I'm just blocked. I tried to do a if A2=A3 or A2=A1 then if B2>B3 etc... but because the number of case# per person varies, it get very long, and gets messed up when I enter a new row. Is there some way I read the col b values into an array for each change in col A, and then return the highest value is col C?

 

[MrKowz]

Welcome to the forums!

This seems to accomplish what you're looking to do.

Excel 2013/2016
	A	B	C
1	Person	Case#	Formula
2	Joe	17	Y
3	Bob	17
4	Bob	18	Y
5	Doug	17
6	Doug	18
7	Doug	19	Y
Sheet1

Cell Formulas
Range	Formula
C2	{=IF(B2=MAX(IF(A:A=A2,B:B)),"Y","")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[dooder]

Oh, my gosh, thank you. I actually tried something similar to that and gave up, but just realize my col b was read in as text.

 

[MrKowz]

Oh, my gosh, thank you. I actually tried something similar to that and gave up, but just realize my col b was read in as text.

Glad I was able to find a working solution for you - thanks for the feedback. Have a good weekend!