Unable to load image

[Join the rDrama leaderboard] Don't forget Advent Of Code! :marseychristmaself2: Santa needs YOU to save christmas:marseypresents:

https://adventofcode.com/

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.:marseymarseylove:

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

99
Jump in the discussion.

No email address required.

gonna see how far I can get just using excel formulas :marseyscratch:

Jump in the discussion.

No email address required.

:marseysweating: the first one made me want to use VBA :marseybrainlet:

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.

made me want to use VBA

VBA makes me want to :marseyobamarope:

Jump in the discussion.

No email address required.

Why can't I downmarsey

Jump in the discussion.

No email address required.

doesn't hate VBA

named Sisyphus

:marseyhmm:

Jump in the discussion.

No email address required.

And yet I am happy

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.



Now playing: Bad Boss Boogie (DKC).mp3

Link copied to clipboard
Action successful!
Error, please refresh the page and try again.