I have a bank balance Excel sheet with:
- Date in column A
- Debit/Credit in Column B
- Running balance in column C
On a separate sheet I want to have a 12 cells for months of the year that state what the balance in my account was on the last entry for that month that has a value in the balance column.
I have googled but can't find what I'm looking for.
Can anyone help please?