Excel Dynamic Arrays Tips: Cumulative Sums by SUBTOTAL with OFFSET & SEQUENCE
In this Video I shared a formula to spill a cumulative range dynamically with functions SUBTOTAL, OFFSET and SEQUENCE. based on the cumulative array values we can easy to calculate other array related to different focused balance values. By the way we can generate dynamci loan schedule report without VAB macros.
References:
SUBTOTAL function - Microsoft Support:
https://support.microsoft.com/en-us/o...
OFFSET function - Microsoft Support:
https://support.microsoft.com/en-gb/o...
