Spreadsheet: 864433d1711600536-array-formula-but-with-different-formula-inbetween-column-a-v-b-1-
Sheet: Report

 | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME] | Actual | Budget | [NAME]
 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00
Sales- Toy
Sales-Food
Sales-Furniture
Sales-Foreign
Sales-Ad Hoc
 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00 | 2024-03-31 00:00:00
Sales- Toy | 4099 | 5000 | -901 | 4698 | 5000 | -302 | 4491 | 5000 | -509 | 4998 | 5000 | -2 | 4240 | 5000 | -760 | 4844 | 5000 | -156 | 4341 | 5000 | -659 | 5159 | 5000 | 159 | 4109 | 5400 | -1291 | 4304 | 5400 | -1096 | 5236 | 5400 | -164 | 5861 | 5400 | 461
Sales-Food | 2042 | 2000 | 42 | 2102 | 2000 | 102 | 2143 | 2000 | 143 | 1910 | 2000 | -90 | 2109 | 2000 | 109 | 2053 | 2100 | -47 | 2132 | 2100 | 32 | 1972 | 2100 | -128 | 1902 | 2100 | -198 | 2164 | 2200 | -36 | 2076 | 2200 | -124 | 1921 | 2200 | -279
Sales-Furniture | 3885 | 3000 | 885 | 4246 | 3000 | 1246 | 3780 | 3000 | 780 | 4160 | 3000 | 1160 | 3628 | 3000 | 628 | 3235 | 3000 | 235 | 4198 | 3000 | 1198 | 3399 | 3000 | 399 | 2885 | 4300 | -1415 | 2553 | 4300 | -1747 | 3893 | 4300 | -407 | 4120 | 4300 | -180
Sales-Foreign | 150 | 800 | -650 | 0 | 800 | -800 | 750 | 800 | -50 | 1100 | 800 | 300 | 600 | 800 | -200 | 0 | 800 | -800 | 600 | 800 | -200 | 0 | 800 | -800 | 0 | 800 | -800 | 500 | 800 | -300 | 1200 | 800 | 400 | 0 | 800 | -800
 | 10176 | 10800 | -624 | 11046 | 10800 | 246 | 11164 | 10800 | 364 | 12168 | 10800 | 1368 | 10577 | 10800 | -223 | 10132 | 10900 | -768 | 11271 | 10900 | 371 | 10530 | 10900 | -370 | 8896 | 12600 | -3704 | 9521 | 12700 | -3179 | 12405 | 12700 | -295 | 11902 | 12700 | -798
* how to make Column A dynamtic? As in the listing will Auto Add on Base on the Column A in Actual and Budget tab?
* is there a way to write an Array formula to replace B3: Ak8?