Learning about probability distributions can be intimidating. So many new terms and concepts. I’ll use everyday language and relatable examples.
Continue readingProbability Distributions in Excel
Post Category → Formulas
How To Play Kakuro
I enjoy Kakuro puzzles. They are challenging and rewarding. In this post I’ll explain:
Continue readingWord Game in Excel
It’s not exactly the same as Wordle but close enough 🙂
Continue readingRounding with a twist
Earlier this week I saw an interesting rounding question on the famous MrExcel Forum. And there was a twist!
Continue readingDSUM gymnastics
I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading
CELL Function Adventure
You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! Continue reading
Flirting with Volatility
I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. Continue reading
Calculate Hours from Messy Text
I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ Continue reading
aggregating text part 2
Haven’t I done this before? It was almost identical except for two details. Continue reading
How many unique List 1 names found in List 2?
Imagine two lists of names. We have three questions: (1)how many unique names in List 1? (2)how many unique names in List 2? (3)how many unique names from List 1 are found in List 2? Continue reading