91
SOLUTION MEGATHREAD-🎄- 2022 Day 7 Solutions -🎄-(self.adventofcode)
submitted 3 years, 1 month ago* (edited 15 minutes after) by daggerdragon to /r/adventofcode (134.8k)
- All of our rules, FAQs, resources, etc. are in our community wiki.
- A reque...
since 3 years, 1 month ago
4 of 4
Tip Reveddit Real-Time can notify you when your content is removed.
your account history
Tip Check if your account has any removed comments.
view my removed comments you are viewing a single comment's thread.
view all comments


Google Sheets
Wasted too much on time on this because I assumed there weren't different directories with the same name. But eventually managed to get a one formula solution for both parts.
This formula will spill one cell to the right with the result of part2 and it assumes that the whole input is in cell A1.
That is actually an insane solve, good job! I also solved it through google sheets, but ended up with almost 400 columns. Also made the mistake of assuming each dir name was unique.
Thanks! I edited my post with a single formula that solves both parts. :)
The new LAMBDA and helper functions are very useful, I totally recommend getting familiar with them. (especially REDUCE, arguably the most powerful function in Sheets)
Thanks for the tip, I will look into those! For now, I'm stuck with regular ol' cell manipulation formulas, although I dabble quite a lot with array formulas ^^