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

 |  |  |  |  |  | aaaa
 |  |  |  |  |  | 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 | BAL B/F | 20 | 27 |  |  | 18 | 7
2020-12-03 00:00:00 | 66B0123 | 20 | 27 |  | 27
19/03/2020 | 0007252/D7002055 | 20 | 27 |  |  |  |  |  | 4 | 23 | 7
20/03/2020 | 0008754/D7002058 | 20 | 27 |  |  |  |  |  | 22
26/03/2020 | 0022789/0007263 | 20 | 27 |  |  |  |  |  |  |  | 2
2020-08-04 00:00:00 | 66C0123 | 20 | 27 |  | 58
16/04/2020 | 66C0123 | 20 | 27 |  | 89
21/04/2020 | 66C0123 | 20 | 27 |  | 6 | 6
21/04/2020 | 66D0123 | 20 | 27 |  | 9 | 5
22/04/2020 | 66B0123 | 20 | 27 |  | 3
22/04/2020 | 66D0123 | 20 | 27 |  | 2 | 22
21/04/2020 | 0006759/D7002064 | 20 | 27 |  |  |  |  |  | 163 | 5
2020-05-05 00:00:00 | 66D0123 | 20 | 27 |  | 79
2020-11-05 00:00:00 | C/0004792/D7002069 | 20 | 27 |  |  |  |  |  | 11 | 3
14/05/2020 | V/0011509/D7002073 | 20 | 27 |  |  |  |  |  | 15 | 25
14/05/2020 | UA/007285/0007001 | 20 | 27 |  |  |  |  |  |  | 5
15/05/2020 | N/0008779/0009602 | 20 | 27 |  |  |  |  |  | 2
15/05/2020 | [NAME] | 20 | 27 |  |  |  |  |  | 3
15/05/2020 | NIG NAVAL/0007279/0009604 | 20 | 27 |  |  |  |  |  | 5
18/05/2020 | LSMH/00022180/0009607 | 20 | 27 |  |  |  |  |  | 4 | 3
20/05/2020 | E/0022184/009608 | 20 | 27 |  |  |  |  |  | 1
21/05/2020 | I/0022308/009609 | 20 | 27 |  |  |  |  |  | 2
22/05/2020 | N/0011518/0009610 | 20 | 27 |  |  |  |  |  | 1 | 3
22/05/2020 | NIGPORT/0011520/0009611 | 20 | 27 |  |  |  |  |  | 2
27/05/2020 | LASUTH/0011521/022252 | 20 | 27 |  |  |  |  |  | 2
27/05/2020 | WWCV/0006787/DV7002074 | 20 | 27 |  |  |  |  |  | 31 | 13
28/05/2020 | OSUN/0022110/0010203 | 20 | 27 |  |  |  |  |  | 2
2020-10-06 00:00:00 | 0022129/66D0123 | 20 | 27 |  | 51
15/06/2020 | SDKF/0011534/0010209 | 20 | 27 |  |  |  |  |  | 3
15/06/2020 | 0022036/66D0123 | 20 | 27 |  | 18 | 4
17/06/2020 | N/0011543/0010210 | 20 | 27 |  |  |  |  |  | 3
18/06/2020 | NAVAL/0004408/0011211 | 20 | 27 |  |  |  |  |  | 5
23/06/2020 | MIN OF HEALTH/0021106/00110212 | 20 | 27 |  |  |  |  |  | 4
24/06/2020 | 0021108/D7002086 | 20 | 27 |  |  |  |  |  | 2
24/06/2020 | FMC/0021111/0010216 | 20 | 27 |  |  |  |  |  | 2
24/06/2020 | AKLM/0021112/0010215 | 20 | 27 |  |  |  |  |  | 1
24/06/2020 | MIN OF HEALTH/0021113/0010214 | 20 | 27 |  |  |  |  |  | 4
25/06/202 | IRRUA/0022653/0010217 | 20 | 27 |  |  |  |  |  | 5
25/06/2020 | LUTH/0022955/0010218 | 20 | 27 |  |  |  |  |  | 2
29/06/2020 | EKITI/0022705/0010219 | 20 | 27 |  |  |  |  |  | 2
30/06/2020 | 66F0123 | 20 | 27 |  | 48
2020-03-07 00:00:00 | 66F0123 | 20 | 27 |  | 35
2020-09-07 00:00:00 | OSUN/002893/0010221 | 20 | 27 |  |  |  |  |  | 5
17/07/2020 | O/002895/0007035 | 20 | 27 |  |  |  |  |  |  | 3
2020-08-07 00:00:00 | 66F0123 | 20 | 27 |  | 54
20/07/2020 | 66F0123 | 20 | 27 |  | 8 | 18
22/07/2020 | MIN OF HEALTH/002898/0010223 | 20 | 27 |  |  |  |  |  | 2
23/07/2020 | FMC/0004427/0010222 | 20 | 27 |  |  |  |  |  | 4
07/08/20 | KADUNA/0007226/0010225 | 20 | 27 |  |  |  |  |  | 3
13/08/2020 | E/0021702/0011797 | 20 | 27 |  |  |  |  |  |  |  | 4
11/08/2020 | GMD/0021602 | 20 | 27 |  |  |  |  |  |  |  | 2
19/08/2020 | V/00022072/D7002107 | 20 | 27 |  |  |  |  |  | 169
27/08/2020 | KE/0021670/0007422 | 20 | 27 |  |  |  |  |  |  |  | 3
28/08/2020 | 66H0123 | 20 | 27 |  | 40
28/08/2020 | WWCV/0021672/D7002113 | 20 | 27 |  |  |  |  |  | 25 | 22
01/09/2020 | 66H0123 | 20 | 27 |  | 20
01/09/2020 | OOU TEACHING HOSP/0004072/0010226 | 20 | 27 |  |  |  |  |  | 4 | 12
2020-07-09 00:00:00 | 66H0123 | 20 | 27 |  | 61
2020-07-09 00:00:00 | CV/0022401/D7002114 | 20 | 27 |  |  |  |  |  | 29 | 6
10/09/2020 | V/0021695/D7002118 | 20 | 27 |  |  |  |  |  | 60
2020-11-09 00:00:00 | 66H0123 | 20 | 27 |  | 26
2020-11-09 00:00:00 | YOBE/0022413/D20200911 | 20 | 27 |  |  |  |  |  | 1 | 13
14/09/2020 | 66H0123 | 20 | 27 |  |  | 5
16/09/2020 | WWCV/0022426/D7002122 | 20 | 27 |  |  |  |  |  | 26
15/09/2020 | MR BABALOLA/0021361/0007433 | 20 | 27 |  |  |  |  |  |  |  | 5
25/09/2020 | 66J0123 | 20 | 27 |  | 10
02/10/2020 | 66J0123 | 20 | 27 |  | 34
06/10/2020 | 66J0123 | 20 | 27 |  | 32
06/10/2020 | WWCV/00121607/D7002125 | 20 | 27 |  |  |  |  |  | 76 | 22
09/10/2020 | 66J0123 | 20 | 27 |  | 75
14/10/2020 | 66J0223 | 20 | 27 |  | 104
14/10/2020 | WWCV YOBE/0022732/D7002126Y | 20 | 27 |  |  |  |  |  | 5
12/10/2020 | CLINIC/0022845/0008302 | 20 | 27 |  |  |  |  |  |  | 1
16/10/2020 | 66J0223 | 20 | 27 |  | 35
19/10/2020 | 66J0223 | 20 | 27 |  | 12 | 24
26/10/2020 | FMC GUASUA/0004084/0010228 | 20 | 27 |  |  |  |  |  |  | 25
28/10/2020 | WWCV/0005867/D7002130 | 20 | 27 |  |  |  |  |  | 129 | 11
28/10/2020 | FOC/0005868/D7002129 | 20 | 27 |  |  |  |  |  | 39 | 16 | 18
28/10/2020 | FOC/0004086/D7002128 | 20 | 27 |  |  |  |  |  | 12 | 13 | 10
28/10/2020 | MR [NAME] | 20 | 27 |  |  |  |  |  |  |  | 10
30/10/2020 | NESTLE/0002466/0010229 | 20 | 27 |  |  |  |  |  | 3 | 9
02/11/2020 | REGULATORY AFFAIR/0021627/0008332 | 20 | 27 |  |  |  |  |  |  |  | 2
03/11/2020 | GMD/0021397/0008333 | 20 | 27 |  |  |  |  |  |  |  | 2
04/11/2020 | MR JAMES/0003859/0008533 | 20 | 27 |  |  |  |  |  |  |  | 4
06/11/2020 | PSN/0004205/0013755 | 20 | 27 |  |  |  |  |  | 3
09/11/2020 | NNPC/0004207/0010230/237 | 20 | 27 |  |  |  |  |  |  | 37 | 10
12/11/2020 | NNPC/0004606/0010239 | 20 | 27 |  |  |  |  |  |  | 12 | 10
09/11/2020 | NNPC/0004209/0010238 | 20 | 27 |  |  |  |  |  |  | 15
09/11/2020 | NNPC/0004208/0010233/234/236 | 20 | 27 |  |  |  |  |  | 4 | 7
13/11/2020 | WWCV/0001805/D7002137 | 20 | 27 |  |  |  |  |  | 25 | 25
18/11/2020 | /0004607/0010710 | 20 | 27 |  |  |  |  |  |  |  | 10
27/11/2020 | U/0004612/0010240 | 20 | 27 |  |  |  |  |  |  | 10
30/11/2020 | 0004406/ 0010727 | 20 | 27 |  |  |  |  |  |  |  | 1
22/12/2020 | 66M0123 | 12 | 12 |  | 211
22/12/2020 | LTD D7002144 | 12 | 12 |  |  |  |  |  | 211
2021-06-01 00:00:00 | 66M0123 0006463 | 12 | 12 |  | 333 | 6
2021-06-01 00:00:00 | 66M0223 0006463 | 12 | 12 |  | 158
2021-06-01 00:00:00 | D7002146 0002917 | 12 | 12 |  |  |  |  |  | 108 | 5 | 4
13/01/2021 | CLINIC 0003838/0008417 | 12 | 12 |  |  |  |  |  |  | 1 | 8
2121-12-01 00:00:00 | 66M0223/ 0002354 | 12 | 12 |  | 103
2021-12-01 00:00:00 | LTD 0003835/D7002149 | 12 | 12 |  |  |  |  |  | 225
2021-12-01 00:00:00 | LTD 0003835/D7002149 | 12 | 12 |  |  |  |  |  | 191 | 8
15/01/2021 | 66M0223/0006469 | 12 | 12 |  | 286
20/01/2021 | 0006474/0008429 | 12 | 12 |  |  |  |  |  |  |  | 1
20/01/2021 | I 0004234/0010245 | 12 | 12 |  |  |  |  |  | 3 | 9
26/01/2021 | 0002929/0008439 | 12 | 12 |  |  |  |  |  |  |  | 4
27/01/2021 | LTD 0006489/D7002153Y | 12 | 12 |  |  |  |  |  | 112 | 6
29/01/2021 | DEPOT 0002495/0010247 | 12 | 12 |  |  |  |  |  | 3 | 5 | 8
2021-03-02 00:00:00 | C 0006499/D7002159 | 12 | 12 |  |  |  |  |  | 20
2021-04-02 00:00:00 | C 0004491/D7002161 | 12 | 12 |  |  |  |  |  | 84 | 2
2021-08-02 00:00:00 | 0000402/66A0123 | 12 | 12 |  | 227
2021-10-02 00:00:00 | 0004419/66A0123 | 12 | 12 |  | 100
16/02/2021 | 0004423/66A0123 | 12 | 12 |  | 210 | 9
2021-12-02 00:00:00 | KADUNA 0004239/0010249 | 12 | 12 |  |  |  |  |  | 2 | 9 | 4
18/02/2021 | WWCV FOC D7002168 | 12 | 12 |  |  |  |  |  | 11 | 3
25/02/2021 | HOSPITAL 0004426/0011905 | 12 | 12 |  |  |  |  |  | 4
25/02/2021 | L 0003061/0011906 | 12 | 12 |  |  |  |  |  | 5
2021-04-03 00:00:00 | 0000384/0007771 | 12 | 12 |  |  |  |  |  |  |  | 3
2021-05-03 00:00:00 | FMC OWO 0011908 | 12 | 12 |  |  |  |  |  |  | 16 | 8
2021-05-03 00:00:00 | 0000389/D20210304 | 12 | 12 |  |  |  |  |  | 5 | 5 | 11
2021-08-03 00:00:00 | LTD 0000394/D7002176 | 12 | 12 |  |  |  |  |  | 277 | 9 | 4
2021-10-03 00:00:00 | IBADAN 0000396/0011909 | 12 | 12 |  |  |  |  |  | 3
2021-10-03 00:00:00 | HOSPITAL 0005207/0011910 | 12 | 12 |  |  |  |  |  | 4 | 1 | 4
16/03/2021 | 0011911/0000425 | 12 | 12 |  |  |  |  |  | 4
18/03/2021 | FOC D7002179 | 12 | 12 |  |  |  |  |  | 15
18/03/2021 | G HOSPITAL 0005208/0011903 | 12 | 12 |  |  |  |  |  | 7 | 6
18/03/2021 | T 00052009/0010250 | 12 | 12 |  |  |  |  |  |  | 2 | 6
19/03/2021 | 0005214/0011914 | 12 | 12 |  |  |  |  |  | 1
22/03/2021 | WWCV FOC 000410/D7002180 | 12 | 12 |  |  |  |  |  | 12 | 9 | 4
24/03/2021 | C.B.N 0004431/0011915 | 12 | 12 |  |  |  |  |  |  | 4 | 2
31/03/2021 | CLINIC 0004115/0007068 | 12 | 12 |  |  |  |  |  |  | 1
2021-06-04 00:00:00 | WWCV LTD0000434/ D7002184 | 12 | 12 |  |  |  |  |  | 313 | 5
2020-06-04 00:00:00 | GMD 0003257/0007069 | 12 | 12 |  |  |  |  |  |  |  | 2
27/04/2021 | 66D0124/0004441 | 12 | 12 |  | 32
28/04/2021 | 66D0124/0002394 | 12 | 12 |  | 48
28/04/2021 | LTD 0003273/D7002189 | 12 | 12 |  |  |  |  |  | 33 | 9 | 8
30/04/2021 | 0003278/0007362 | 12 | 12 |  |  |  |  |  |  |  | 2