So here is what I am trying to achieve
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
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?
Person | Case# | |
Joe | 17 | Y |
Bob | 17 | |
Bob | 18 | Y |
Doug | 17 | |
Doug | 18 | |
Doug | 19 | Y |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
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?