Spreadsheet: 684618d1593463086-how-to-enter-date-associated-with-last-number-greater-than-zero-or-last-zero-in-row-last-date-using-last-zero-or-last-number-greater-than-zero
Sheet: Sheet1

0
Volume Ends |  | Last volume | 01/2020 | 02/2020 | 03/2020 | 04/2020 | 05/2020 | 06/2020 | 07/2020 | 08/2020 | 09/2020 | 10/2020 | 11/2020 | 12/2020 | 2020 | 01/2021 | 02/2021 | 03/2021 | 04/2021 | 05/2021 | 06/2021 | 07/2021 | 08/2021 | 09/2021 | 10/2021 | 11/2021 | 12/2021 | 2021 | 01/2022 | 02/2022 | 03/2022 | 04/2022 | 05/2022 | 06/2022 | 07/2022 | 08/2022 | 09/2022 | 10/2022 | 11/2022 | 12/2022 | 2022
 | 2022-07-01 00:00:00 |  | 1680 | 961 | 1740 | 0 | 840 | 120 | 0 | 60 | 844 | 1316 | 1144 | 1030 | 9735 | 974 | 1024 | 1178 | 1024 | 1024 | 1126 | 870 | 1124 | 1074 | 5312 | 5410 | 4298 | 24438 | 3570 | 3506 | 4032 | 3330 | 3680 | 3734 | 0 | 0 | 0 | 0 | 0 | 0 | 21852
 | 2021-01-01 00:00:00 |  | 8100 | 6121 | 5820 | 180 | 1830 | 2352 | 2580 | 3864 | 3442 | 4774 | 4153 | 0 | 43216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2022-01-01 00:00:00 |  | 64920 | 62050 | 46200 | 0 | 20550 | 45780 | 56070 | 55236 | 57910 | 62467 | 59025 | 3797 | 534005 | 2840 | 2988 | 3436 | 2988 | 2988 | 3288 | 2538 | 3286 | 3136 | 3136 | 2838 | 2538 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2020-10-22 00:00:00 |  | 0 | 169 | 0 | 0 | 16 | 0 | 60 | 0 | 123 | 1581 | 7251 | 6867 | 16067 | 7006 | 7374 | 8480 | 7374 | 7374 | 8112 | 6266 | 8110 | 7742 | 7742 | 7004 | 6266 | 88850 | 7254 | 7636 | 8782 | 7254 | 8018 | 8398 | 6108 | 8780 | 8016 | 0 | 0 | 0 | 70246
 | 2021-04-01 00:00:00 |  | 0 | 54 | 0 | 0 | 20 | 0 | 0 | 2842 | 7683 | 7386 | 6422 | 5780 | 30187 | 4170 | 4388 | 5046 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13604 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2021-04-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0 | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 570 | 598 | 688 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1856 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2022-10-01 00:00:00 |  | 18880 | 15854 | 12800 | 0 | 1600 | 14258 | 10748 | 15566 | 15324 | 18174 | 15803 | 14223 | 153230 | 12822 | 13498 | 15522 | 13498 | 13498 | 14846 | 11472 | 14844 | 14170 | 14170 | 12820 | 11470 | 162630 | 13184 | 13878 | 15960 | 13184 | 14572 | 15266 | 11104 | 15958 | 14570 | 0 | 0 | 0 | 127676
 | 2022-02-01 00:00:00 |  | 18900 | 15800 | 12600 | 0 | 1500 | 14158 | 10748 | 15517 | 10868 | 12374 | 10760 | 9684 | 132909 | 12822 | 13498 | 15522 | 13498 | 13498 | 14846 | 11472 | 14844 | 14170 | 14170 | 12820 | 11470 | 162630 | 11760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11760
 | 2020-02-22 00:00:00 |  | 48300 | 43800 | 36000 | 0 | 4200 | 34126 | 30896 | 45528 | 29876 | 32588 | 28336 | 25502 | 359152 | 34468 | 36282 | 41724 | 36282 | 36280 | 39908 | 30838 | 39908 | 38094 | 38094 | 34466 | 30838 | 437182 | 32666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32666
 | 2021-01-01 00:00:00 |  | 0 | 900 | 1440 | 0 | 0 | 0 | 0 | 0 | 0 | 240 | 720 | 480 | 3780 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2020-09-01 00:00:00 |  | 8100 | 8100 | 5400 | 0 | 0 | 2700 | 5400 | 8100 | 0 | 0 | 0 | 0 | 37800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2020-08-01 00:00:00 |  | 53400 | 44280 | 33960 | 0 | 1560 | 36960 | 38798 | 0 | 0 | 0 | 0 | 0 | 208958 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2020-11-22 00:00:00 |  | 548028 | 555497 | 400298 | 180 | 84958 | 449848 | 495089 | 472366 | 437608 | 437042 | 426600 | 306546 | 4614060 | 292106 | 305452 | 306978 | 260734 | 260034 | 288097 | 220930 | 282512 | 272716 | 273770 | 258868 | 225198 | 3247395 | 166112 | 84066 | 96676 | 79858 | 87102 | 92332 | 49174 | 71196 | 41742 | 19156 | 0 | 0 | 787414
 | 2020-07-22 00:00:00 |  | 120060 | 139382 | 82370 | 0 | 17262 | 120434 | 148394 | 137390 | 132238 | 139722 | 121512 | 109003 | 1267767 | 93180 | 97752 | 68518 | 59580 | 59580 | 65536 | 50642 | 65530 | 62548 | 62548 | 56590 | 50632 | 792636 | 16752 | 17634 | 20278 | 16750 | 18510 | 19388 | 0 | 0 | 0 | 0 | 0 | 0 | 109312
 | 2020-11-22 00:00:00 |  | 427968 | 416115 | 317928 | 180 | 67696 | 329414 | 346695 | 334976 | 305370 | 297320 | 305088 | 197543 | 3346293 | 198926 | 207700 | 238460 | 201154 | 200454 | 222561 | 170288 | 216982 | 210168 | 211222 | 202278 | 174566 | 2454759 | 149360 | 66432 | 76398 | 63108 | 68592 | 72944 | 49174 | 71196 | 41742 | 19156 | 0 | 0 | 678102