9 posts
Dijkstra's Algorithm in Google Sheets
2023-02-13 • 15 min read
Dijkstra's algorithm implementation in Google Sheets using a single formula and without resorting to Apps Scripts..
Advent of Code 2022 Day 7 in Google Sheets
2022-12-22 • 9 min read
Advent of Code 2022 Day 7 one-formula solution in Google Sheets.
How to Use Column Names in QUERY - Google Sheets
2022-11-12 • 4 min read
Learn how to refer to the columns with their header when using the Google Sheets QUERY function.
Advent of Code 2021 Day 9 Part 1 in Google Sheets
2022-09-25 • 6 min read
Advent of Code 2021 Day 9 Part 1 one-formula solution in Google Sheets.
Advent of Code 2021 Day 3 Part 1 in Google Sheets
2022-09-07 • 5 min read
Advent of Code 2021 Day 3 Part 1 one-formula solution in Google Sheets.
Extract Nth Words in Google Sheets
2022-08-31 • 5 min read
Learn how to extract specific words from a string based on a numerical input in another cell using only Google Sheets built-in functions.
Site Introduction
2022-08-20 • 1 min read
How I built this website and the things I have learned along the way.