Hello Everybody,
I have a business requirement to come up with a list of conflicting duties for any person who has duties assigned.
I am not able to get the logic to do this on Excel and would need some help.
Tables I have (Inputs):
1) Name and Duty
<tbody>
</tbody>
2) Duty and Conflict
<tbody>
</tbody>
Output required:
1) Name, Duty, Conflict
<tbody>
</tbody>
I have attached a sample of the requirement. It has the input tables and the required output.
Please advice.
Warm regards.
I have a business requirement to come up with a list of conflicting duties for any person who has duties assigned.
I am not able to get the logic to do this on Excel and would need some help.
Tables I have (Inputs):
1) Name and Duty
<tbody> </tbody> |
<tbody> </tbody> | ||
Tom |
<tbody> </tbody> | ||
Tom | duty2 | ||
Tom | duty3 | ||
Tom | duty4 | ||
Megan | duty5 | ||
Megan | duty6 | ||
Megan | duty7 | ||
Vince | duty8 | ||
Vince | duty9 |
<tbody>
</tbody>
2) Duty and Conflict
Duty | Conflict |
duty1 | duty3 |
duty3 | duty1 |
duty5 | duty6 |
duty6 | duty5 |
<tbody>
</tbody>
Output required:
1) Name, Duty, Conflict
Name | Duty | Conflict | ||
Tom |
<tbody> </tbody> | duty3 | ||
Tom |
<tbody> </tbody> |
<tbody> </tbody> | ||
Megan |
<tbody> </tbody> |
<tbody> </tbody> | ||
Megan |
<tbody> </tbody> | duty5 |
<tbody>
</tbody>
I have attached a sample of the requirement. It has the input tables and the required output.
Please advice.
Warm regards.