Excel_Blonde
New Member
- Joined
- Aug 8, 2018
- Messages
- 44
Hi there,
I have my IT guru trying to create a report that will tell me if previous operations within a work structure have not been completed (Either Inventory or Pending status). I was wondering if any of you great people can help. For example from the data in the table below I would B/75 and B/76 to be returned. I believe they attempting this using SQL but are trying to get the formula correct in excel first but is just falling short. Any help would be greatly appreciated.
<tbody>
</tbody>
I have my IT guru trying to create a report that will tell me if previous operations within a work structure have not been completed (Either Inventory or Pending status). I was wondering if any of you great people can help. For example from the data in the table below I would B/75 and B/76 to be returned. I believe they attempting this using SQL but are trying to get the formula correct in excel first but is just falling short. Any help would be greatly appreciated.
Job No | Op No | Predecessor | Status |
B/75 | 10 | Inventory | |
B/75 | 20 | 10 | Pending |
B/75 | 30 | 20 | Complete |
B/76 | 10 | Complete | |
B/76 | 20 | 10 | Inventory |
B/76 | 30 | 20 | Pending |
B/76 | 40 | 30 | Complete |
B/76 | 50 | 40 | Pending |
B/77 | 10 | Complete | |
B/77 | 20 | 10 | Complete |
B/77 | 30 | 20 | Pending |
<tbody>
</tbody>