#### propilot81

##### New Member

- Joined
- Apr 12, 2013

- Messages
- 4

As seen in the example below, customer A1111 must have Task 5 in their work order. In work order 111111, Task 5 is present and work order is OK, however, in work order 333333 Task 5 is not present for customer A1111 and needs to be flagged "Need Task 5." Customer B1111 is a customer that does not apply.

Column A | Column B | Column C | Column D | |

Task | Work Order | Customer # | Exceptions | |

<tbody> </tbody> | 111111 | A1111 | Ok | |

<tbody> </tbody> | 111111 | A1111 | Ok | |

Task 2 | 111111 | A1111 | Ok | |

Task 1 | 222222 | B1111 | Not Applicable | |

Task 2 | 222222 | B1111 | Not Applicable | |

Task 1 | 333333 | C1111 | Need Task 5 | |

Task 2 | 333333 | C1111 | Need Task 5 |

<tbody>

</tbody>