Spreadsheet: 473387d1470178452-array-formulas-limitatins-could-be-pc-memory-size-problem-scratch
Sheet: MT - COPIED DATA

FittingNum |  |  | [NAME] OF ITEM | WEIGHT OFF (Kgs) | WEIGHT ON (Kgs) | CODE CNT | 1 | 2 | 3 | 4 | 5 | 6 | 1 | 2 | 3 | 4 | 5 | 6 | ON/OFF kg EQUAL or  NOT EQUAL |  | Fault Examination
dghdfhfg-001 |  |  | Could be this or that - xxx001 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | No Code | No Code
dghdfhfg-001 |  |  | Could be this or that - xxx001 | -1 | 0
dghdfhfg-002 |  |  | Could be this or that - xxx002 | -99.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | TEXT in Kg | [NAME]) have TEXT - not Number
dghdfhfg-002 |  |  | Could be this or that - xxx002 | 0 | 0
dghdfhfg-002 |  |  | Could be this or that - xxx002 | 0 | 0
dghdfhfg-003 |  |  | Could be this or that - xxx003 | -61.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | ON-OFF NO Kg | NO kg
dghdfhfg-003 |  |  | Could be this or that - xxx003 | 0 | 0
dghdfhfg-004 |  |  | Could be this or that - xxx004 | -61.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] (-) | [NAME] is NOT Negative (-)
dghdfhfg-004 |  |  | Could be this or that - xxx004 | 0 | 0
dghdfhfg-004 |  |  | Could be this or that - xxx004 | 0 | 0
dghdfhfg-005 |  |  | Could be this or that - xxx005 | -67.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] (+) | [NAME] is NOT Positive (+)
dghdfhfg-005 |  |  | Could be this or that - xxx005 | 0 | 0
dghdfhfg-006 |  |  | Could be this or that - xxx006 | -67 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | ON-OFF-CE? | ON & OFF kg Count Error ">1" ∆ (Should not be more than 1)
dghdfhfg-006 |  |  | Could be this or that - xxx006 | 0 | 0
dghdfhfg-006 |  |  | Could be this or that - xxx006 | 0 | 0
dghdfhfg-006 |  |  | Could be this or that - xxx006 | -0.1 | 0
dghdfhfg-007 |  |  | Could be this or that - xxx007 | -75.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | ON-OFF-SL? | ON & OFF kg Same Line (row) | [NAME] required
dghdfhfg-007 |  |  | Could be this or that - xxx007 | 0 | 0
dghdfhfg-007 |  |  | Could be this or that - xxx007 | 0 | 0
dghdfhfg-007 |  |  | Could be this or that - xxx007 | 0 | 0
dghdfhfg-007 |  |  | Could be this or that - xxx007 | 0 | -170.5
dghdfhfg-007 |  |  | Could be this or that - xxx007 | 0 | 0
dghdfhfg-008 |  |  | Could be this or that - xxx008 | -41.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ON-OFF kg MM? | ON & OFF [NAME] (Not all entries are equal weight) | [NAME] required
dghdfhfg-008 |  |  | Could be this or that - xxx008 | 0 | 0
dghdfhfg-009 |  |  | Could be this or that - xxx009 | -41.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | True | All Conditions OK
dghdfhfg-010 |  |  | Could be this or that - xxx010 | -68.5 | 0
dghdfhfg-010 |  |  | Could be this or that - xxx010 | 0 | 0
dghdfhfg-011 |  |  | Could be this or that - xxx011 | -66.5 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | More Alarms | Fitting No. Count does not match Weight entry count?
[NAME] |  |  | Could be this or that - xxx012 | -75 | 0
[NAME] |  |  | Could be this or that - xxx012 | 0 | 0
dghdfhfg-013 |  |  | Could be this or that - xxx013 | -76 | 0
dghdfhfg-014 |  |  | Could be this or that - xxx014 | -75.5 | 0
dghdfhfg-014 |  |  | Could be this or that - xxx014 | 0 | 0
dghdfhfg-015 |  |  | Could be this or that - xxx015 | -146 | 0
dghdfhfg-016 |  |  | Could be this or that - xxx016 | -149 | -149
dghdfhfg-016 |  |  | Could be this or that - xxx016 | 0 | 0
dghdfhfg-017 |  |  | Could be this or that - xxx017 | -20 | 0
dghdfhfg-018 |  |  | Could be this or that - xxx018 | -20 | 0
dghdfhfg-018 |  |  | Could be this or that - xxx018 | -132000 | -132000
dghdfhfg-018 |  |  | Could be this or that - xxx018 | 0 | 0
dghdfhfg-018 |  |  | Could be this or that - xxx018 | -3 | 0
[NAME] |  |  | Could be this or that - xxx019 | -20 | 0
[NAME] |  |  | Could be this or that - xxx019 | -132000 | 0
dghdfhfg-020 |  |  | Could be this or that - xxx020 | -20 | 0
dghdfhfg-020 |  |  | Could be this or that - xxx020 | 0 | 0
dghdfhfg-020 |  |  | Could be this or that - xxx020 | 0 | 0