Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAHi All,
Please find my Answer Below.
Thanks
Mat
Agree with previous comments about retention rate being the inverse of the provided solution, but other than that calculation difference got this batch macro working in no time compared to previous attempts at similar things.
Really good found this one quite tough to start with. Then I went back to basics and built it without the batch macro.
After that it was easy to see which bits needed to be moved into the macro.
Not entirely sure what the point of doing it with a macro is (Efficiency?) but I appreciated the practice nonetheless.
Nice one thanks for the challenge.