Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Super cool challenge!
I was going to use 2 macros (1 to go through the numbers and another to iterate through each number's processing) but thought maybe I could put it all together with a single macro.
Initially i thought the code had an issue but quickly realized 100 iteration was way too low for all numbers iterations combined (when going up to 10,000) since many numbers would 100+ iterations.
With 2 macros, a max of 261 iterations would be enough in the macro config, but using a single macro I had to bump the number up to 900,000 (Alteryx did 849,665 iterations in 43 minutes). Either with 1 or 2 macros however, the same grand total iterations (for all 10,000 numbers) are required.
Additional conclusions:
These are the top 5 most popular number of iterations:
Count iterations
190 52
184 47
175 39
160 44
153 60
And the most iterations needed award goes to....
Additional spoilers..
Workflow and macro spoiler:
