saralouise
New Member
- Joined
- Oct 11, 2018
- Messages
- 2
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.
<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>
</tbody>
open to VBA or formula.
thank you!
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.
A | B | C |
ID # | Type | |
1 | Type 1 | |
1 | Type 1 | |
PRIORITY | 2 | Type 1 |
2 | Type 2 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
9 | Type 1 | |
PRIORITY | 9 | Type 1 |
9 | Type 2 | |
9 | Type 2 | |
9 | Type 2 | |
12 | Type 1 | |
16 | Type 1 | |
16 | Type 1 | |
16 | Type 1 | |
PRIORITY | 16 | Type 1 |
16 | Type 2 | |
13 | Type 2 | |
14 | Type 2 | |
15 | Type 2 |
<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>
</tbody>
open to VBA or formula.
thank you!