Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThank you, @gawa! This was a tough one.
I leveraged the solution from @RolandSchubert with a single macro. Thank you both, @gawa and Roland, for sharing your expertise on this.
Workflow:
Macro:
Macro:
A quick edit to the solution I just submitted: you can convert 'Integer to Letter' input to a macro input - this way, you can update this reference table at anytime without having to modify the macro :)
Funny how sometimes you're trying to solve a work conundrum and a weekly challenge turns out to be exactly what you need!
One of the best challenges (and perhaps the hardest!) I've tried so far! THANK YOU @gawa !!! 😀
Took me some thinking and sleeping on it, but very happy with my final solution! I can't believe I actually did it!
Along with figuring out the macro which surprisingly didn't take long, the other harder part was trying to figure out the algorithm for the base conversion. Once that was done, adapting it for bases greater than 10 was straight forward. I chose to limit from bases 2 to base 32 (max), but if we use additional non-letter/number characters, the code should work for any base size.
Anyway, loved it! Thanks again for this creative puzzle!
The interface and Results:
The flow:
The macro: