https://infoinspired.com/excel-formula/running-balance-dynamic-array-formulas-in-excel/
Creating a Running Balance with Dynamic Array Formulas in Excel
Mar 28, 2024 - For calculating a running balance, we can utilize the SCAN function, which is a dynamic array function available in Excel.
dynamic arrayin excelcreatingrunningbalance