Advent of Code in Google Sheets

Google Sheets one formula solutions to Advent of Code.

Instructions

To use the formulas on your input:

• Copy the relevant formula(s) from the day##.md file.
• Create a Google Sheets spreadsheet. You can quickly create one by going to sheets.new.
• Double click on any empty cell not in column A and paste (Ctrl+V) the formula(s).
• Format column A as Plain text. (Click on the column label > Format > Number > Plain text)
• Copy the puzzle input.
  • If the formula expects the input in A:A click once on cell A1 and paste the input as values only (Ctrl+⇧+V).
  • If the formula expects the input in cell A1 double click on cell A1 and paste (Ctrl+V) the input.

2023 (☆28)

01~05	☆★	☆★	☆★	☆★	☆
06~10	☆★	☆★	☆	☆★
11~15	☆★		☆★	☆	☆★
16~20	☆		☆★	☆
21~25	☆