The second interesting change I made in the updated library instruction spreadsheet was a type of conditional formatting that I haven’t specifically discussed before: formatting that depends on something other than the contents of the cell being formatted.

Last week I was focusing on how to use incremental formulas to determine the most recent time something was used, but in the process of adding that to the example spreadsheet I also ended up making a couple of other… Read moreNifty trick: Pulling just 1 year’s data

There’s another type of incremental formula that can be used to track how recently someone did a particular thing, or how recently a particular thing was used. These things could be almost anything, though it works best with finite sets…. Read moreProject: Use tracking

If I’m going to discuss finding and replacing, I really need to also discuss wild cards. Most people are probably familiar with the concept of wild cards, in one form or another. I assume the term comes from card games,… Read moreWild cards and regular expressions