Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANth Factorial.
This would be an interesting one to come back and try to improve! It's definitely far from perfect as is... Although as I've learnt with Alteryx, if it works, then the 'most optimal' solution is likely just a millisecond faster to run!
Batch macro with the following configuration:
Interestingly, i ran into problems with the first row - so had to have a filter to apply the rowcount to 2 for that. However, everything else went swimmingly!
Somehow I always assume an iterative program is required and spent ages looking into an iterative macro solution. For some reason I thought the challenge required it, but when I realised a standard macro would do, I went with the generate rows function like many others. An important lesson here in not over-engineering. "Keep it simple stupid".