place text in row for all matching instances in range

[saralouise]

here's what I'm trying to accomplish:
if any of the same ID number in column B have Type 1 and Type 2 in column c, mark all rows associated with that same ID number with "priority" in column A

i have =IF(AND(B3=B4,C3<>C4),"PRIORITY","") in column A and have been trying to use it as a helper column, but i can't figure out how to check to see if the ID number in the row with "PRIORITY" is matched anywhere else in column B and then also place the text for all matching instances.

PRIORITY

PRIORITY

PRIORITY

<colgroup><col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> </colgroup><tbody>
[TD="class: xl65, width: 98"]A[/TD]
[TD="class: xl66, width: 98"]B[/TD]
[TD="class: xl65, width: 98"]C[/TD]

[TD="class: xl66"]ID #[/TD]
[TD="class: xl65"]Type[/TD]

[TD="class: xl66"]1[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]1[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]2[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]2[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]9[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]12[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]16[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]16[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]16[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]16[/TD]
[TD="class: xl65"]Type 1[/TD]

[TD="class: xl66"]16[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]13[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]14[/TD]
[TD="class: xl65"]Type 2[/TD]

[TD="class: xl66"]15[/TD]
[TD="class: xl65"]Type 2[/TD]

</tbody>

open to VBA or formula.

thank you!

 

[Firesword]

Hi Saralouise, If I've understood your request then this should work
=IF(SUMIFS($B:$B,$B:$B,B3,$C:$C,"Type 1")>0,IF(SUMIFS($B:$B,$B:$B,B3,$C:$C,"Type 2")>0,"PRIORITY",""),"")

 

[saralouise]

yes, thank you!! so simply elegant that i hadn't occurred to me - i got down the rabbit hole of far more complicated solutions.