What an interesting challenge!
Took a little while to wrap my head around this one. Lots of bug finding later.
This is tough challenge...
GitHub
https://github.com/AkimasaKajitani/AdventOfCode/tree/main/2021
Only Part 1 (for now...) I hope I have time to solve Part2 (Is it as hard as I think?)
Ooof, this one was rough. Took a while to wrap my brain around how to approach, but once I figured it out, it was just a matter of going through a lot of Parse + Join + Filter iterations... possibly the most RegEx parse tools I've ever used in a workflow 🙂 This one is ugly... but it did the trick.
Here's the final messy beast. Not my finest work, but glad that after a (restless) night's sleep, my brain figured out how to finish this one.
Cheers!
NJ
I have created the worst formula nightmare ... but ... I might have won tool golf ... (only took hours to figure out every detail). Decision was on purpose to not build a macro and/or build something smart. I quickly came to the point where I knew "this could be a one formula thing" and I decided I'll never leave that path.
You really don't want to click on Spoiler two ....
All other numbers are found in a similar way. Used some help columns for 5/6 and than it was just figuring out what is left.
The idea is to reorder each entry, then use the number with unique letter count to match match others, eg when 1 (2 letters) concatenate with 2, 3, 5 (5 letters), after remove duplicate letters, only results left represents 3. After a bit iteration on the macro we can deduce all the numbers for each line.
Though the workflow is definitely not something efficient, will look out for better ideas from others.
