Notifications
Clear all
General Excel Questions & Answers
6
Posts
4
Users
0
Reactions
159
Views
Topic starter
1. column B (Beginning Balance) is not a Dynamic Array while all other columns are dynamic Array starting from row 6. How can I make Column B a dynamic Array?
2. How can I create a Dynamic Array for cumulative Interests (Column D) and Cumulative Principal payments (Column E)?
3. You may download the attached Excel file.
Posted : 03/07/2023 2:03 pm
For B6 you can use
=VSTACK(A2,DROP(SCAN(A2,E6#,LAMBDA(a,b,a-b)),-1))
Posted : 03/07/2023 2:42 pm
Alternatively, in B6 enter:
=FILTER(VSTACK(F5,F6#),VSTACK(F5,F6#))
Posted : 04/07/2023 1:26 am
I am asuiming the OP is using Office 365?
It doesn't work with 2021 (in my case)
Posted : 04/07/2023 2:16 am
Topic starter
Riny,
Your solution is great for me. Thanks, you all!
Posted : 06/07/2023 12:37 am
You could (should) mention the Office version in your profile
Posted : 07/08/2023 3:04 am
