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
[TABLE="width: 431"]
<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>[TR]
[TD="width: 139, bgcolor: aqua"]CONTRACT NUMBER
[/TD]
[TD="width: 102, bgcolor: aqua"]LINE ITEM ID[/TD]
[TD="width: 115, bgcolor: lime"]PURCHASE QTY[/TD]
[TD="width: 104, bgcolor: lime"]SHIPPED QTY[/TD]
[TD="width: 114, bgcolor: lime"]ACCEPTED QTY
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0001[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0003[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0005[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0007[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]1423
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001AA[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001AC[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001BC[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001BE[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0006
[/TD]
[TD="bgcolor: transparent"]0001CA[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0006
[/TD]
[TD="bgcolor: transparent"]0001CB[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
</tbody>[/TABLE]
Z941714
[TABLE="width: 431"]
<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>[TR]
[TD="width: 139, bgcolor: aqua"]CONTRACT NUMBER
[/TD]
[TD="width: 102, bgcolor: aqua"]LINE ITEM ID[/TD]
[TD="width: 115, bgcolor: lime"]PURCHASE QTY[/TD]
[TD="width: 104, bgcolor: lime"]SHIPPED QTY[/TD]
[TD="width: 114, bgcolor: lime"]ACCEPTED QTY
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0001[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0003[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0005[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]0007[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0001
[/TD]
[TD="bgcolor: transparent"]1423
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001AA[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001AC[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001BC[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0005
[/TD]
[TD="bgcolor: transparent"]0001BE[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0006
[/TD]
[TD="bgcolor: transparent"]0001CA[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]0006
[/TD]
[TD="bgcolor: transparent"]0001CB[/TD]
[TD="bgcolor: transparent"]1[/TD]
[TD="bgcolor: transparent"]1
[/TD]
[TD="bgcolor: transparent"]0[/TD]
[/TR]
</tbody>[/TABLE]