In Canada we have long harsh winters but July was REALLY hot this year! How hot? Let’s combine heat & humidity to determine the real temperature we feel.
Post Category → Articles
Excel ChessGames Viewer
On July 20 I woke up early and started doing tactics on Chess.com I then noticed an email from Robert Gascon with subject heading “Excel ChessGames Viewer“! Robert also reminded me that it was International Chess Day! Continue reading
Sum Cells in Overlapping Ranges
This is a cruel Excel challenge (I’ve used it!). Why? Because there is a brilliantly simple solution to summing cells that overlap two ranges. Continue reading
Partial Match Count with a Condition
Once again I discovered a formula that I had written down in a notebook. What is it doing? Is there an easier way to solve this? Continue reading
Largest Number Inside Alphanumeric String
A friend shared this challenge: extract the largest number from this text as420lkjs09nsdk2324lkjsd099 ! The answer is 2324. How do we solve this? Formulas? VBA? Continue reading
Dynamic Ranges Using Index Function
Robert H. Gascon’s comment from my last post convinced me that I should be using the INDEX function for dynamic ranges not the volatile OFFSET function. Continue reading
What is this formula doing?
=SUMPRODUCT(MID(G2,{1;2;3},1)*1) I found this formula in a notebook. Can you understand it’s purpose? I’ll explain it in this post. I’ll also expand it for a more complex case. Continue reading
False Friends in Excel
The term False Friends is used in various fields including linguistics and chess. In this post I’ll explain how it applies to Microsoft Excel! Continue reading
Harvard CEO Ranking
Harvard Business Review ranked the top 100 CEOs with three weighted categories (80%, 10%, 10%). I downloaded their data and added some formulas to modify the weighting. Does it make a difference? Continue reading
The Learning Curve in Excel
I’ve had this ‘Business Formulas’ book sitting around for years. I decided to explore the learning curve formula: (a) create it in Excel and (b) think about the factors that go into learning Excel.
Continue reading