Forum Discussion
Solved
I need to be able to minus from one row until it goes down to 0 then move to the next row
Im using 2016 windows excel, I quickly sketched up a mockup so it is easier to visualise the problem. My issue is I have no idea how to go about this. I need to minus the cash flow down into the ...
Joshscott See attached in the green shaded area. I believe this works as desired.
I've set a bit of a layout of what I was hoping to happen, if that is even possible.
Ideally for each column it checks if there is a balance in it, if not it moves downwards and checks the other accounts.
Many thanks for any help 🙂
Joshscott See attached in the green shaded area. I believe this works as desired.
- Thank you so much man, honestly helped me so much 🙂
I was really not sure if it can be done, cheers