Return value of the latest balance for each accounts

[Goodvibe]

Hi everyone!

I am trying to figure out two formulas :S:

1)Return the balance of LAST MONTH and THIS MONTH for each accounts (it would update as the months go by) in the tab named "Projection"
2)The latest balance for each accounts from the latest date that is in the table (in the tab named "Épargnes et Inv.)

Your help is greatly appreciated !Wish I could do more on my side regarding formulas but no luck so far :S!

[AliGW]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...-accounts.html