You’ve got a column with a bunch of rows of values. And maybe rows get added or removed from time to time. So, the location of the last (or perhaps latest) value is always changing. Here’s how you find that last value and grab it so you can do stuff with it.
Google Sheets: Set Conditional Formatting Based on a Different Cell’s Value
You want to apply conditional formatting to a cell. The trouble is… the conditional formatting depends on the value that’s in a different cell. Here’s how you do it.
Google Sheets Formula to Get Column by Name / Label
So, you’re working with Google Sheets and you realize, “Hey, I need to get a specific column. But wait… I …
The Fundamental Principles of SEO
All too often, when people talk about search engine optimization they try to look cool or convince you they’re “experts” …
Auto-Lead Data Format XML Template Generator
Here’s a handy little tool I created to generate a customized ADF template.
Query Google Sheets by Column Name
One of the most handy functions in Google Sheets is the QUERY function. Unfortunately, Google Sheets doesn’t have a feature …