Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAIt was quite easy to do without macro but have to admit that was diffcult for me to implemnet a batch macro. It is great that you forced me to go out from my comfort zone.
Macro:
and workflow without macro:
The biggest challenge was figuring out whether the Open column was referring to the act of opening an account or whether the account was still open.
I misunderstood the explanation initially as the denominator referencing the act of opening. When in fact the 'Open' column referred to the state of the account (whether an account is Open at the Start of Month).
And the Batch macro: