For the past 82 years (approximately), I've used Excel almost every day. Along the way, I've learned a few tricks, and produced some sophisticated workbooks. One of the joys of Excel is that there's always something new to learn.

This week, while working on a client's files, I wanted to review some calculations in a [...]