Spreadsheet: 731983d1620734241-excel-formula-that-can-convert-total-units-to-cartons-rolls-and-pieces-help-2
Sheet: bbbb

 |  |  |  |  |  | bbbb
 |  |  |  |  |  | HALL B
DATE | DETAILS | UNIT IN | ROLLS IN | TOTAL |  | RECEIPTS |  |  |  | ISSUES
 | WAYBILL/ INVOICE NO. | A ROLL | A CTN | UNITS/CTN | CARTONS | ROLLS | PCS | T/UNITS | CARTONS | ROLLS | PCS | T/UNITS | CLOSING STOCK
 |  | PACK SIZE
2020-11-03 00:00:00 | BALANCE B/F | 12 | 12 |  |  |  | 3
17/03/2020 | 000682/0007254 | 12 | 12 |  |  |  |  |  |  |  | 2
24/03/2020 | 71A0122 | 12 | 12 |  | 33
25/03/2020 | 71A0122 | 12 | 12 |  | 49
25/03/2020 | 000683/0010292 | 12 | 12 |  |  |  |  |  | 15
25/03/2020 | 000684/0010293 | 12 | 12 |  |  |  |  |  | 5
26/03/2020 | 71A0122 | 12 | 12 |  | 33 | 9 | 10
27/03/2020 | 71A0122 | 12 | 12 |  | 6 | 4 | 3
2020-07-04 00:00:00 | 0010294/003370 | 12 | 12 |  |  |  |  |  | 10
24/04/2020 | AARCE/0006763/2020039 | 12 | 12 |  |  |  |  |  | 3
29/04/2020 | JOS/002857/0010296 | 12 | 12 |  |  |  |  |  | 10
2020-04-05 00:00:00 | /0022168/0007279 | 12 | 12 |  |  |  |  |  |  |  | 1
2020-05-05 00:00:00 | AKURE/000900/0010298 | 12 | 12 |  |  |  |  |  | 10
2020-05-05 00:00:00 | BENIN/000899/0010300 | 12 | 12 |  |  |  |  |  | 5
2020-07-05 00:00:00 | KADUNA/003842/0011752 | 12 | 12 |  |  |  |  |  | 10
2020-08-05 00:00:00 | ABUJA/003843/0011754 | 12 | 12 |  |  |  |  |  | 10
14/05/2020 | KANO/000690/0011755 | 12 | 12 |  |  |  |  |  | 5
14/05/2020 | SOKOTO/000961/0011756 | 12 | 12 |  |  |  |  |  | 5
14/05/2020 | ONITSHA/003849/0011999 | 12 | 12 |  |  |  |  |  | 10
14/05/2020 | FMC GASAU/007285/0007001 | 12 | 12 |  |  |  |  |  |  | 2 | 1
20/05/2020 | YOLA/003371/0010152 | 12 | 12 |  |  |  |  |  | 5
22/05/2020 | [NAME] | 12 | 12 |  |  |  |  |  | 10
28/05/2020 | BEINN/003376/0011762 | 12 | 12 |  |  |  |  |  | 9
24/0*9/2020 | KANO RECALL | 12 | 12 |  |  |  | 14
13/10/2020 | REJECT | 12 | 12 |  |  |  |  |  |  |  | 14
24/11/2020 | 71G0123 | 12 | 12 |  | 200 | 5
25/11/2020 | IBADAN/0007248/0013757 | 12 | 12 |  |  |  |  |  | 30
26/11/2020 | APAPA/0004097/0013760 | 12 | 12 |  |  |  |  |  | 10
26/11/2020 | [NAME] | 12 | 12 |  |  |  |  |  |  |  | 540
27/11/2020 | KADUNA/004611/001376 | 12 | 12 |  |  |  |  |  | 6
28/11/2020 | ACPN/0006579/0013763 | 12 | 12 |  |  |  |  |  | 2
09/12/2020 | /0002486/0010739 | 12 | 12 |  |  |  |  |  |  |  | 1
10/12/2020 | JOS/0002487/0013770 | 12 | 12 |  |  |  |  |  | 5
11/12/2020 | IBADAN/0003052/0013771 | 12 | 12 |  |  |  |  |  | 20
15/12/2020 | AKURE DEPOT 0013775 | 12 | 12 |  |  |  |  |  | 3
2021-06-01 00:00:00 | C 0005441 0008412 | 12 | 12 |  |  |  |  |  |  |  | 3
20/01/2021 | AKURE DEPOT 0004235/0013781 | 12 | 12 |  |  |  |  |  | 10
21/01/2021 | KADUNA 0002493/0013782 | 12 | 12 |  |  |  |  |  | 5
21/01/2021 | KANO 0002492/0013783 | 12 | 12 |  |  |  |  |  | 5
29/01/2021 | ABUJA DEPOT 0002495/0010247 | 12 | 12 |  |  |  |  |  |  | 4 | 2
2021-09-02 00:00:00 | ABULE EGBA DEPOT 0002362/0011051 | 12 | 12 |  |  |  |  |  | 10
2021-12-02 00:00:00 | KADUNA DEPOT 0004239/0010249 | 12 | 12 |  |  |  |  |  | 1 | 7
17/02/2021 | ILORIN DEPOT 0002365/0011055 | 12 | 12 |  |  |  |  |  | 10
23/02/2021 | ABUJA DEPOT 0004260/0011061 | 12 | 12 |  |  |  |  |  | 10
28/02/2021 | . HOSPITAL 0004426/0011905 | 12 | 12 |  |  |  |  |  | 1 | 4 | 8
24/02/2021 | GMD 0000413/0007771 | 12 | 12 |  |  |  |  |  |  |  | 2
2021-05-03 00:00:00 | FMC OWO 0011908 | 12 | 12 |  |  |  |  |  |  | 3 | 4
2021-10-03 00:00:00 | HOSPITAL 0005207/0011910 | 12 | 12 |  |  |  |  |  | 2 | 8 | 11
18/03/2021 | DGMD 0004244/0007053 | 12 | 12 |  |  |  |  |  |  |  | 3
20/04/2021 | APAPA DEPOT 0002388/0011085 | 12 | 12 |  |  |  |  |  | 5
21/04/2021 | REGULATORY AFFIAR 0003084/0007087 | 12 | 12 |  |  |  |  |  |  |  | 5
28/04/2021 | KADUNA DEPOT 0002396/0011091 | 12 | 12 |  |  |  |  |  | 2
30/04/2021 | 0003278/0007362 | 12 | 12 |  |  |  |  |  |  |  | 1
 |  | 12 | 12