John Dalesandro

Hi, I’m John!

Profile photo of John Dalesandro.

I write code.

In many languages.

Across multiple platforms.

To solve problems.

For fun.

Featured Projects

Quartiles Solver

Generate possible solutions to the Apple News+ Quartiles game by comparing all 1- to 4-tile combinations against a large word list.

Wordle Solver

Find possible solutions to The New York Times Wordle game by searching a list of known 5-letter words.

Spelling Bee Solver

Find possible solutions to The New York Times Spelling Bee game by searching known words with at least 4 letters including the required and optional letters.

Analytical Spam Filter

Plugin for WordPress to block comment spam, trackback spam, and pingback spam through intelligent analytics instead of interactive challenge-response tests.

Head Trimmer

Customizable plugin for WordPress to selectively remove version information, feeds, shortlinks, xmlrpc, emoji support and other extras from the HEAD element.

Latest Blog Posts

Excel Multi-Criteria Lookup Guide

Learn how to perform Excel multi-criteria lookups with SUMPRODUCT, INDEX with MATCH, and XLOOKUP. Step-by-step examples included.