Not sure how or if this can be done. Workload pull has in column "A" contract number, (hundreds of contract numbers), column "B" has the line item for each contract number, column "C" purchase qty, column "D" shipped qty, column "E" accepted qty. Need a formulas in column "F" to identify contracts in column "A" that complete. (complete equals purchase qty = shipped qty = accepted qty.
Z941714
<colgroup><col width="139" style="width: 104pt; mso-width-source: userset; mso-width-alt: 5083;">
<col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;">
<col width="115" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4205;">
<col width="104" style="width: 78pt; mso-width-source: userset; mso-width-alt: 3803;">
<col width="114" style="width: 86pt; mso-width-source: userset; mso-width-alt: 4169;">
<tbody>
</tbody>
Z941714
CONTRACT NUMBER | LINE ITEM ID | PURCHASE QTY | SHIPPED QTY | ACCEPTED QTY |
0001 | 0001 | 1 | 1 | 1 |
0001 | 0003 | 1 | 1 | 1 |
0001 | 0005 | 1 | 1 | 1 |
0001 | 0007 | 1 | 1 | 1 |
0001 | 1423 | 1 | 1 | 1 |
0005 | 0001AA | 1 | 0 | 0 |
0005 | 0001AC | 1 | 0 | 0 |
0005 | 0001BC | 1 | 0 | 0 |
0005 | 0001BE | 1 | 0 | 0 |
0006 | 0001CA | 1 | 1 | 0 |
0006 | 0001CB | 1 | 1 | 0 |