Spreadsheet: 685014d1593670267-how-to-list-latest-date-vol-appears-using-product-class-as-criteria-by-evaulating-table-pq-how-to-list-latest-date-vol-appears-using-product-class-as-criteria-by-evaulating-table-rev1
Sheet: Sheet1

 |  |  |  |  |  | Product Class | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | 2020 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | 2021 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | 2022
 | Product Class | [NAME] with Volume | Value |  |  | MBG | 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 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 21852
 | MGY | 2020-11-01 00:00:00 | 4153 |  |  | MGY | 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
 | TYP | 2022-10-01 00:00:00 | 19156 |  |  | TYP | 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
 | MBG | 2022-01-01 00:00:00 | 11760 |  |  | NOP | 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
 | WDT | 2022-10-01 00:00:00 | 19156 |  |  | WDT | 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
 | NOP | 2022-09-01 00:00:00 | 8016 |  |  | TYP | 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
 |  |  |  |  |  | WDT | 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
 |  |  |  |  |  | MBG | 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
 |  |  |  |  |  | NOP | 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
 |  |  |  |  |  | NOP | 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
 |  |  |  |  |  | MBG | 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
 | Expected results |  |  |  |  | MBG | 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
 | Last date with volume |  |  |  |  | TYP | 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
 | 2022-01-01 00:00:00 |  |  |  |  | WDT | 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-01 00:00:00 |  |  |  |  | WDT | 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
 | 2022-10-01 00:00:00
 | 2022-09-01 00:00:00
 | 2022-10-01 00:00:00