It's not going to win any awards for beauty, but it got across the finish line.
Iterative Macro
This was a good one, a little bit needle in a haystack finding the matches but it was satisfying when I worked out the approach to pairing of rules and ticket parts. And yes its nice to be back in Base A!
Macro:
Day16!
Today's workflow is far from elegant.
Possible Column Position Calculator Macro :
Outer Macro: Grouping by each Field Name
Inner Macro: Join Field is overwrited by Control Parameter.
Search Correct Field macro: Find count 1 Field.
AS anonymous user #1105310
Ran out of steam on Sunday so am missing a few days, trying not to look at the threads in detail but it looks like I missed some trickier ones!
Anyway nice to be back involved, here's my tidied up solution with an iterative macro to whittle down the field name/column numbers.
 
 
Macro-free solution (with annotations) below. Runs in 2 seconds but certainly a lot of tools.......!
This was much better than yesterday's 😅
My solutions so far: https://github.com/dsmdavid/AdventCode2020
Like @Steph_Maddrell's solution, macro free. Lots of tools, but fast 1.6 seconds for both parts
Ugly but fast.
Very messy but gets the job done. It made sense when I was building it, but I used way too many tools.
