“Retreating with enthusiasm is a sign of wisdom and long-term thinking.”
Seth Godin
Monthly Archives: August 2024
Hyperlink Drop Down List
I recently saw a post on LinkedIn about making a drop-down list for a hyperlink interface. It was using a range name and the ADDRESS function. I thought I could streamline it with just the CELL function.
“We first make our habits, and then our habits make us.”
John Dryden
Counting the Number of Cells in an Excel Range
Excel has functions to count the number of rows and columns in a range. It doesn’t have a function to count the number of cells in a range. We can still perform the calculation with the COUNTA function.
Some nice feedback
It was a nice start to the day to receive this email this morning.
“Doth thou love life? Then do not squander time, for that is the stuff life is made of.”
Benjamin Franklin
Excel’s Magic Percentage Symbol
I recently saw a post of LinkedIn (from Patryk Samborski) that used the percentage symbol with the SEQUENCE function to produce a list of decimals and I thought I would have a play with that idea.
“It is not how much we have, but how much we enjoy, that makes happiness.”
Charles Spurgeon
Working Backwards in Excel
I recently received a request to help with a salary packaging calculation. I thought I would share the solution and explain the technique to solve it. This is a case where we have a value we need to equal but don’t know the components that make it up. We are in effect working backwards to find the missing value.
“Logic will get you from A to B. Imagination will take you everywhere.”
Albert Einstein