Spreadsheet: 742654d1627936406-help-with-formula-for-a-difot-report-sample-for-difot-help
Sheet: Sheet1

CustomerName | OrderNo | Required | ProductDescription | OrderUOM | REQ Qty | DES QTY | Order Date | DESPATCH Date | [NAME] | Desired Result
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 1 | P | 5 | 5 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 10 | P | 7 | 7 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 11 | P | 10 | 8 | 2021-01-05 00:00:00 | 2021-01-05 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 2 | P | 5 | 4 | 2021-01-05 00:00:00 | 2021-01-05 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 5 | P | 6 | 6 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 6 | P | 87 | 87 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 7 | P | 43 | 43 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 8 | P | 56 | 56 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
CUSTOMER 1 | 112233 | 2021-01-08 00:00:00 | Product 9 | P | 98 | 98 | 2021-01-05 00:00:00 | 2021-01-22 00:00:00 |  | FAIL
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 12 | P | 76 | 76 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | FAIL | Fail because other lines on the Sales Order 445566 failed making the whole order a fail
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 13 | P | 8 | 8 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | FAIL | Fail because other lines on the Sales Order 445566 failed making the whole order a fail
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 14 | P | 123 | 89 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | FAIL
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 17 | P | 5 | 5 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | FAIL | Fail because other lines on the Sales Order 445566 failed making the whole order a fail
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 18 | P | 45 | 45 | 2021-01-05 00:00:00 | 2021-01-15 00:00:00 |  | FAIL
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 19 | P | 54 | 54 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | FAIL | Fail because other lines on the Sales Order 445566 failed making the whole order a fail
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 21 | P | 14 | 14 | 2021-01-05 00:00:00 | 2021-01-15 00:00:00 |  | FAIL
Customer 2 | 445566 | 2021-01-08 00:00:00 | Product 3 | P | 11 | 11 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | FAIL
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 15 | LM | 76 | 76 | 2021-01-05 00:00:00 | 2021-01-07 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 15 | LM | 34 | 34 | 2021-01-05 00:00:00 | 2021-01-07 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 16 | LM | 76 | 76 | 2021-01-05 00:00:00 | 2021-01-07 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 16 | LM | 45 | 45 | 2021-01-05 00:00:00 | 2021-01-07 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 20 | LM | 23 | 23 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 20 | LM | 45 | 45 | 2021-01-05 00:00:00 | 2021-01-08 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 4 | LM | 67 | 67 | 2021-01-05 00:00:00 | 2021-01-07 00:00:00 |  | PASS
Customer 3 | 778899 | 2021-01-08 00:00:00 | Product 4 | LM | 45 | 45 | 2021-01-05 00:00:00 | 2021-01-07 00:00:00 |  | PASS