Advent of Code 2023 Day 4 (BaseA Style)

[AlteryxCommunityTeam]

Discussion thread for day 4 of the Advent of Code - https://adventofcode.com/2023/day/4

[PangHC]

Spoiler

[AkimasaKajitani]

My solution.

Part 1 was very easy. But it took so much time for part 2 because I didn't understand the question correctly and wasted my time. But I am satisfied in the execution time(less than 1 sec). 

Spoiler

 

 

[IraWatt]

My first macro in AoC. Definitely learned a bit from the challenge today.  

Spoiler

[Ladarthure]

My solution with a quick working macro

[Samantha_Jayne]

Spoiler

Only have time for star 1 at the moment and I have dance later... so may have to catch up on this one. Will update my pic & file when I do.

[caltang]

Spoiler

No luck with a non-macro solution... tried doing a many-to-many join but the idea fell flat. Would love to see a different appraoch.

[PangHC]

non-macro version.

I just random test and boom, hit the result.

Spoiler

then use multiple-rows formula and get above row based on the max winning number (which is 10).
(change the [count] to 1, as it just referred to original copy)

1+
iif([Row-1:Sum_match]>0,[Row-1:Count2],0)+
iif([Row-2:Sum_match]>1,[Row-2:Count2],0)+
iif([Row-3:Sum_match]>2,[Row-3:Count2],0)+
iif([Row-4:Sum_match]>3,[Row-4:Count2],0)+
iif([Row-5:Sum_match]>4,[Row-5:Count2],0)+
iif([Row-6:Sum_match]>5,[Row-6:Count2],0)+
iif([Row-7:Sum_match]>6,[Row-7:Count2],0)+
iif([Row-8:Sum_match]>7,[Row-8:Count2],0)+
iif([Row-9:Sum_match]>8,[Row-9:Count2],0)+
iif([Row-10:Sum_match]>9,[Row-10:Count2],0)​

then sum the count2

[DataNath]

Day 4 done and dusted! Took me a little while to debug my part 2 macro but we got there in the end!

Spoiler

[mbarone]

Part I only.  Hope to work on Part II without a macro (not sure it's possible, but going to try) later.

Spoiler

Part II:  Gave up on the non-macro approach, so here it is with the macro.

Spoiler

[rachel_k]

Perfect use case for a simple iterative macro - I feel good getting this one done quickly after I was a mess on yesterday's puzzle!

Spoiler