Spreadsheet: 88085d1288013731-auto-assigning-sale-item-invoice-number-against-stock-list-excel-tests
Sheet: 111

AAA111 |  |  | BBB111 |  |  | CCC111 |  |  | DDD111 |  |  | EEE111 |  |  | GGG111 |  |  | HHH111 |  |  | III111
Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv | Purc. # | Cost | Cust. Inv
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91017 | 102.30504 |  | 91003 | 91.305795 |  | 91017 | 102.30504 |  | 91017 | 102.30504
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91017 | 102.30504 |  | 91003 | 91.305795 | 910678 | 91017 | 102.30504 |  | 91017 | 102.30504
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91017 | 102.30504 |  | 91003 | 91.305795 | 910536 | 91017 | 102.30504 |  | 91017 | 102.30504
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91017 | 102.30504 |  | 91003 | 91.305795 | 910470 | 91017 | 102.30504 |  | 91017 | 102.30504
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91017 | 102.30504 |  | 91003 | 91.305795 | 910449 | 91017 | 102.30504 |  | 91017 | 102.30504
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  | 91003 | 91.305795 | 910429 | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  | 91003 | 91.305795 | 910427 | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  | 91003 | 91.305795 | 910417 | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  | 91003 | 91.305795 | 910357 | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91017 | 102.30504 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  | 91003 | 91.305795 | 910325 | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  | 91003 | 67.827162 |  | 91016 | 95.7606 |  | 91010 | 99.43218399999999 |  |  |  |  | 91010 | 99.43218399999999 |  | 91010 | 99.43218399999999
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  | 91003 | 93.91453199999998 |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  |  |  |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  |  |  |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  |  |  |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  |  |  |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 |  | 91023 | 41.300584 |  |  |  |  |  |  |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694
91016 | 95.7606 | 10001 | 91023 | 41.300584 | 10002 |  |  |  |  |  |  | 91006 | 97.447694 |  |  |  |  | 91006 | 97.447694 |  | 91006 | 97.447694