Look up a list of items and return matches in Google Sheets

Anyone who’s spent time in spreadsheets dreads receiving that request to match a random list of things with another of list of things. Right? Except when you are used to using VLOOKUP. That tried-and-true method is very good at finding a match in a list against a another (usually longer) list. But what happens when…

A modest proposal for Slack Overload

How do you keep up with these Slack communities that are out there? For many of us, opening Slack creates an overwhelming feeling of “FOMO” (Fear of Missing Out). When all of the channels light up with notifications, you collapse the channel view, mute the channel, or just close Slack altogether. But wait! You’re missing…

A few things, done easier

Have you recently read about a product and thought: “it does too much?” Yet it’s also easy to disqualify a product or service as too narrow and “not for me”. How do you split the gap and build for the people who really want (and need) what you are selling without simply disappearing into the…

Applying Regular Expressions to Sort Items in Google Sheets

Lists are more useful when grouped. When you need to analyze a large list of items, you need to create areas of commonality to enable grouping and sorting that list. A simple example of grouping might be to think about a grocery list, where certain items (bananas, oranges) are fruits and other items (paper plates,…

Spreadsheets are not scary

What was the last document you created? I’m guessing it was either an email, a Word document, or a Google Doc. Perhaps it was a Slack message but since when you use Slack you create several hundred messages a month (or day), so let’s not count that. Why wasn’t it a spreadsheet (Excel or Google…