Spreadsheet: 328444d1403897733-a-formula-that-can-be-used-in-whole-column-that-brings-back-a-positive-result-excel-formula-help
Sheet: Sheet2

Transaction | Component | Component Desc | Component Cat | Component U/M | Component OH | Unit Cost | Trans Date | Trans User | Trans W/H | [NAME] | Trans Lot | Trans Qty | Tot Comp Qty (issued) | [NAME] (Based on FG Fin Qty)    w/ scrap factored in | [NAME] | BOM Qty Per       [Inc. scrap factored in] | [NAME] into BOM | [NAME] |  |  | Raw % | Req'd Qty Excl  Scrap | Req'd Qty Inc. Factrored-in Scrap | Actual Issued         (WIP Balance) | Additional Scrap/Yield Loss: Fav/(Unfav)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What it is currently
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140527 | Innovatum | 13 | LINE28 | 1404001998 | -52 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1404001998 | 52 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1404001998 | -52 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140528 | Innovatum | 13 | [NAME] | 1404001998 | 34.218 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
CX - Component Reconciliation | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1404001998 | -0.501 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | FL-FULL UNITS W/LABELS
CX - Component Reconciliation | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1404001998 | -0.727 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | LF-WASTE LABELS / FILM
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140527 | Innovatum | 13 | RR0304 | 1405003664 | -16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1405003664 | 16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1405003664 | -16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | Innovatum | 13 | LINE28 | 1405003664 | -16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | Innovatum | 13 | [NAME] | 1405003664 | 15 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
CX - Component Reconciliation | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1405003664 | -0.501 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | FL-FULL UNITS W/LABELS
CX - Component Reconciliation | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1405003664 | -0.064 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | FN-FULL UNITS W/O LABELS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | What I need it to do.
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140527 | Innovatum | 13 | LINE28 | 1404001998 | -52 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1404001998 | 52 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1404001998 | -52 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140528 | Innovatum | 13 | [NAME] | 1404001998 | 34.218 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | 01-NORMAL
CX - Component Reconciliation | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1404001998 | -0.501 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | FL-FULL UNITS W/LABELS
CX - Component Reconciliation | 0032.3.1482 | P&G-LBL-H&S SH 50ML FRONT | CLBL  - Rm label | M | 1101.821 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1404001998 | -0.727 | 16.554 | 17.01972 | -0.46572 | 0.037 | 0.03 | LF-WASTE LABELS / FILM
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140527 | Innovatum | 13 | RR0304 | 1405003664 | -16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1405003664 | 16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140527 | BPCS USER - Mark S Huller | 13 | WOWO | 1405003664 | -16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | Innovatum | 13 | LINE28 | 1405003664 | -16 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
I - Shop Order Component Issue | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | Innovatum | 13 | [NAME] | 1405003664 | 15 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | 01-NORMAL
CX - Component Reconciliation | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1405003664 | -0.501 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | FL-FULL UNITS W/LABELS
CX - Component Reconciliation | 0032.5.81 | P&G-BTL-HDPE 50ML OVAL WHITE | CBOT  - Rm bottle | M | 223 | 4.26279 | 20140528 | BPCS USER - [NAME] | 13 | SCRAP | 1405003664 | -0.064 | 16.435 | 17.01972 | -0.58472 | 0.037 | 0.03 | FN-FULL UNITS W/O LABELS