When faced with a challenge in Microsoft Excel it’s rare that two very different approaches can both be equally amazing! In this post I’ll review two completely different solutions from Oz du Soleil and David Hager. Continue reading
Date Archives → May 2018
Retrieve 1st Code for Selected City When Description is not blank
In Microsoft Excel there are often many different ways to create a solution. The best solution is often subjective based on whether we emphasize simplicity or efficiency. Here is a good example: Continue reading
Excel Error “You can’t enter an array formula over merged cells”
You created a cool array formula and then merged it across several cells. Later, you realize that you need to modify this array formula. When you try to press Control Shift Enter you get this horrible error: Continue reading
Variable Sized Groups Within Each Column
Every once in a while we get a unique challenge in Excel. This one required some creativity to quickly create a solution due to a pending deadline.
Continue reading
Excel data concept taught backwards
I’ve been a data analyst since 2001. It’s often challenging to accurately & quickly explain certain concepts. There is one that is a classic. I’m going to explain it with the help of Hugh MacLeod’s book “Evil Plans”. No nerdy data terms. The concept first. Continue reading