Advent of Code is an annual coding competition/event with daily challenges. Even complete beginners can keep up for the first few days as the difficulty slowly ramps up.
Join the rDrama leaderboard and see how you compare to your fellow dramanauts with the following code:
632268-20c7d1d5
Enter it here https://adventofcode.com/2022/leaderboard/private
Jump in the discussion.
No email address required.
gonna see how far I can get just using excel formulas
Jump in the discussion.
No email address required.
the first one made me want to use VBA
I eventually figured out you could just sum all the numbers up to that point but subtract the partial sums that came before, something like this:
=IF(A19="",SUM(A$1:A19)-SUM(B$1:B18),"")
had to put a manual Sum(A1:A9) for the first elf on row 9 but the code drags down fine after and then a simple Max() of the range gets the answer
The second part would be super easy just by sorting the sums column but I did it instead with the Large() function (completely forgot that one existed)
Jump in the discussion.
No email address required.
lmfao ur a nerd doxxer 🤓🤓 great thighs for a codecel tho 😮💨
Jump in the discussion.
No email address required.
More options
Context
VBA makes me want to
Jump in the discussion.
No email address required.
Why can't I downmarsey
Jump in the discussion.
No email address required.
Jump in the discussion.
No email address required.
And yet I am happy
Jump in the discussion.
No email address required.
More options
Context
More options
Context
More options
Context
More options
Context
More options
Context
More options
Context