Advent of Code 2022 Day 6 (BaseA Style)

[AlteryxCommunityTeam]

Discussion thread for day 6 of the Advent of Code - https://adventofcode.com/2022/day/6

[MeganBowers]

I used a hard-coded multi-row formula that wouldn't work for tons of letters for part one, then got stuck for a bit on part 2 until I used the multi-row formula tool more like a running total and assigned points based on where letters matched in the previous sequence. Not the simplest, but it made sense in my head!

Spoiler

 

 2nd multi-row formula

[DataNath]

Here's my stab at this. Wasted a load of time faffing around with an enormous Multi-Row Formula to try and chop out a couple tools but eventually gave up in the hopes of slipping in another hour of sleep.

Spoiler

[Jotigautam]

Old Style!

Spoiler

[AkimasaKajitani]

My 2nd solution.

There are 4 tools using by Generate row.

Spoiler

[aravind_sk]

Spoiler

If it went more than 14, that'd be a lotta lines on the 'IF'.

[Ladarthure]

My solution, could have been made with a bit less tools maybe :)

Spoiler

 

[FrederikE]

Finally joining in too.

I probably made it overly complicated with a batch macro in an iterative macro. 

Spoiler

 Edit: Omg - is my solution overly complicated :D

[Jean-Balteryx]

Day 6 done ! ✔️

I feel like it was too easy compared to yesterady. A bit worried about tomorrow ...

Spoiler

[Pang_Hee_Choy]

Spoiler

length(replacechar()) on A-Z to get part1 (i.e. 26-4=22) and part2 (i.e. 26-14=12)

[peter_gb]

Probably could have minimised the number of tools, I tend to always want to unique ID everything along the way but I suppose it's good practice!

Felt a little manual when I was copy and pasting in the multi-row but that seems to have been most people's approach today.

Spoiler