This content has been marked as final. Show 5 replies
I have a monthly spreadsheet which I download from my bank to show Date, Transactions, Money In, Money Out and Balance.
I want to be able to display a Straight Table showing the Last day of the month and the balance on that day. The main issue I have is that because there are more than one transactions on the last day of the month there are multiple Balances and I only want the Minimum Balance within that group.
I have tried
I have tried some weird and wonderful Set Analysis expressions which give me some amazing results, none of which are correct including using max(RecNo())
Anyone got any ideas??