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
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.
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 …