11.ods (2.0 MB)
How can i calculate the remainder for each debt? There 366 debts and 366 payments, and each payment must close first past debts.
I’m looking for a formula that applies regardless of what numbers are written on the payment row, and to be able to drag it down and over.
Deleted the last post because this way is easier to calculated for all of them.
Can you help please?
Thank you.
I don’t think I’m understanding what you’re trying to do. Perhaps if you put in some correct values in those cells it will help.
But I’ll have a guess:
In D3 is the correct value C3-D2?
And E3 is the correct value D3-E2?
Yes, but i’ve found a problem with this way of calculating: afterwards it is impossible to extract the results based on the day they occur. It works only for the first day. I’m updating soon the situation, the debts must be written diagonally and the rows transformed into columns.
I’ve done it, it works with the columns and rows reversed, no macro needed, just to copy the formulas, but there are about 1500 columns, which makes the whole file slower.
I still can’t quite work out what you’re trying to do, but I’m glad it’s working 
I can show how i did it, just that i don’t know how, it would take a lot just to recreate it from scratch.
