Spreadsheet: 880917d1728740437-byrow-bycol-in-same-formula-sample
Sheet: Sheet1

Table 1
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00
Bank1 | 823.8922185866819 | 967.5122438351123 | 266.4124005958304 | 385.6088761100721 | 657.868317615728 | 957.7834716185262 | 488.6074274056116
Bank3 | 981.417764843988 | 464.4915377357385 | 849.7290302091169 | 55.06050338406821 | 905.2729167325831 | 208.760944158208 | 753.714654930978
Bank4 | 424.8760092267722 | 657.8145259972713 | 661.4880107264133 | 717.1192094778739 | 548.630346827557 | 867.2179889729839 | 578.5455567045922
Bank5 | 795.9651343646885 | 71.27220170873483 | 300.8601379299845 | 386.5826521943512 | 330.5143723534135 | 263.1075983386622 | 571.2280619936153
Bank6 | 903.5686352697245 | 256.5765176957559 | 812.8456828974321 | 385.3377543002019 | 443.5021171977797 | 679.6115351722657 | 502.0711955746915
[NAME] | 967.1302878263739 | 385.3675387577389 | 449.5079354064742 | 516.0332344026912 | 652.632180359616 | 744.3036510424412 | 752.5714917672346
Table 2 |  |  |  |  |  |  |  |  |  | Results
 | Bank1 | Bank3 | Bank4 | Bank5 | Bank6 | [NAME] |  |  |  |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00
Account1 | 4.793570598426183 | 8.575150576376998 | 0.5896007509076662 | 4.92990489785022 | 6.276395624219605 | 0.5264794302905962 |  |  |  | Account1 |  | 11173.40005317343 | 15775.24449815107 | 7339.438291413971 | 15996.45925240931 | 12847.13846273129 | 15510.01263630875
Account2 | 2.748188120962705 | 9.041315125235624 | 0.7940715424450595 | 8.240335957435267 | 3.714197891791168 | 8.540227275229858 |  |  |  | Account2 |  | 12212.28102947094 | 18277.24639766576 | 11150.82175891812 | 20372.88659894108 | 16257.10484339653 | 21615.7978959622
Account3 | 1.8230873656406 | 7.884512612221105 | 4.325206992875749 | 8.156123967798282 | 2.273000434841502 | 5.366882514001969 |  |  |  | Account3 |  | 11504.05847735425 | 16760.37235797666 | 11037.19158358357 | 17916.32389632727 | 14828.28430731247 | 19174.9537311061
Account4 | 9.549142285982104 | 4.726772126100886 | 2.692886373145976 | 1.525180465101421 | 1.518969611869251 | 1.557383720271983 |  |  |  | Account4 |  | 14304.47754073845 | 10735.40770214939 | 7852.199431221718 | 14232.65518053361 | 15060.85779464599 | 12592.27607410162
Account5 | 1.387087269153672 | 3.087130967942028 | 8.332919299213149 | 6.466292058686912 | 2.016203181385536 | 6.215059156829361 |  |  |  | Account5 |  | 11630.74479931282 | 14882.91824603018 | 13164.40126726822 | 15366.44967850373 | 16896.91588754424 | 17208.81179317997
Account6 | 6.118553660978483 | 1.351991396116948 | 2.409390074077229 | 4.303523344653483 | 5.784973357858728 | 2.838263025546991 |  |  |  | Account6 |  | 11017.48027317097 | 11645.53855345817 | 9519.103992635117 | 12411.35434583979 | 15408.31283054065 | 12901.28604327559
Account7 | 6.80333766786722 | 7.21943575780688 | 5.38421268788958 | 1.112635735821919 | 6.209223053850743 | 3.809667425316274 |  |  |  | Account7 |  | 16618.05561301157 | 18603.01343889302 | 11670.74424996217 | 19573.05967636345 | 20040.69859665943 | 18500.65606831356
Account8 | 7.857287015512293 | 0.3105613750164982 | 3.47472689578432 | 8.173031066574627 | 2.181811051927849 | 1.402955849918684 |  |  |  | Account8 |  | 11714.96539098922 | 9518.716630112722 | 10262.99072782057 | 11941.09980299992 | 15281.15408675652 | 12903.40501794978
Account9 | 0.37323795761951 | 2.374473046376677 | 1.895851486946841 | 5.10925697170681 | 9.821461083590888 | 4.851428114793466 |  |  |  | Account9 |  | 7464.840766771049 | 15072.43636239459 | 9897.44308048311 | 12645.92898062272 | 14127.29313011535 | 14569.54858527604
Account10 | 2.214649660722483 | 4.975672989871568 | 9.20854986409905 | 0.3398074957202946 | 9.861837605273271 | 0.7196020408991044 |  |  |  | Account10 |  | 13343.22257146998 | 19351.18272882377 | 12034.42023279418 | 15969.07231988739 | 18472.92808112966 | 15846.90168718034
Account11 |  |  |  |  | 5.75299842344419 | 2.418610946500567 |  |  |  | Account11 |  | 2408.138449461932 | 5763.484745325311 | 3464.931122467028 | 4129.930316489286 | 5709.985048332117 | 4708.592444610435
[NAME] |  |  |  |  | 5.18075956118069 | 8.382141804066764 |  |  |  | [NAME] |  | 4559.466603778295 | 7978.997300065668 | 6321.806001249248 | 7768.133315747853 | 9759.76270705477 | 8909.271108558027
Account13 |  |  |  |  | 2.112706958441447 | 1.395274951280565 |  |  |  | Account13 |  | 1079.764668173814 | 2344.491893070991 | 1534.114000850604 | 1847.591342742656 | 2474.328259841709 | 2110.773460034338
Account14 |  |  |  |  | 4.221277363827526 | 6.458188685736702 |  |  |  | Account14 |  | 3571.856924894216 | 6334.254144090813 | 4959.257535539151 | 6086.967211282717 | 7675.682207533571 | 6979.630466248414