Advent of Code 2024 Day 2 (BaseA Style)

[MeganBowers]

Discussion thread for day 2 of the Advent of Code - https://adventofcode.com/2024/day/2

[nehajain01]

Day 2 solved with a some manual checks

[kendi]

It is just Day 2 and it already is a already a head scracher 😅

Spoiler

MAIN WORKFLOW:

MACRO:

[SeanAdams]

Non macro solution

Spoiler

Just used a multi-row for part 1,
and a cartesian join for part 2

With part 1 - don't worry about whether it's ascending or descending - just check both  and see if either give you a hit
With part 2 - create copies of each record with one character knocked out - and then check each of them for a hit - same as part 1

Original code of all solutions here: SeanAdams10/AdventOfCodePython: Advent of code challenges in Python - across multiple years

And here it is in Python for anyone else doing a dual-solve this year

[Qiu]

Keep a cool head is very important during the process. 😁

Spoiler

[SeanAdams]

Your V2 is pretty slick @CoG - nicely done!

(I split the asc and desc - but with your carrying over the direction flag you can avoid this)

[Jeff_Neklason]

You ever had that moment when creating a macro and you realized you accidentally developed a brute force copy paste solution for the problem... 

Spoiler

 

[NicoleJ]

Day 2! Solution is definitely going to need to be refactored because *** ew, Part 2 is embarrassing *** but I know it can easily be done with a macro... Here's a picture of the "before" while I decide how motivated I am to create an "after"!

Spoiler

 

Today's "new Designer feature shout out" definitely goes to the new Expression Editor in the Multi-Row Formula tool, and the Group By option in Record ID! ❤️

[suwenchuan]

Spoiler

[estherb47]

Not elegant in any way, but it works without a macro.

Spoiler

Took the ones that failed the first round, created the combinations of eliminated records, and redid the same analysis from part 1

[AnnaRa]

Yay! finally figured out a batch macro - had to do an 8 filter  solution first to understand how it should work - but got it!!!