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.
Christ OpenOffice fricking sucks. I want to play and this would be fricking easy even in Excel but OO is throwing me bullshit errors and I can't buy Excel because of a one-way feud with Microsoft. (the solution is way easier than what @BasicallyADoxxer is doing)
What's the basic b-word freeware that lets me enter some goddarn if statements?
Jump in the discussion.
No email address required.
I think google sheets has similar formulas and works well
Jump in the discussion.
No email address required.
I HATE THE ANTICHRIST
Thanks anyway. I saw your solution and I think mine might be a little more elegant (I'm very drunk so there could easily be an infinite loop I'm missing):
Jump in the discussion.
No email address required.
You can make a throwaway gmail
Also looking at your sheet, that will just keep summing up the total calories of all the elves, not the total calories of each elf
With a slight edit tho
for B cells:
=if(A9>0,B8+A9,"")
for C cells:=if(B9="",B8,"")
it should work, and I agree it is much simpler than my solution just requires an extra column
Jump in the discussion.
No email address required.
More options
Context
More options
Context
More options
Context
More options
Context