Feb 1, 20221 minAll of My Best Formulas in One PlaceI call this file my "Cheat Sheets Formula Repository". It's where I dump all of my favorite Google Sheets formulas. I use this daily.
Nov 1, 20212 min2 Tips for Using IMPORTRANGEIMPORTRANGE is what allows your Google Sheets files to talk to each other. Here are two tips to improve that talk.
Oct 1, 20212 minFormula: Mimic SQL's "IN" and "NOT IN" FunctionsFilter a range if a match is found within a (maybe long?) list of options. Or don't. I don't care.
Sep 1, 20213 min6 Google Sheets Formula TricksSix of my favorite Sheets formula tricks. Hopefully these will save you some time… and some headaches.