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.

lmfao ur a nerd doxxer 🤓🤓 great thighs for a codecel tho 😮‍💨

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.



Now playing: Bayou Boogie (DKC2).mp3

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