How tall is tall? How smart is smart? How do we compare? Normal Distribution and Standard Deviation answer this. We’ll review the concepts and use Excel to crunch the numbers. Continue reading
Post Category → Videos
Learn VBA UDF
These days dynamic arrays, power query and DAX seem to be all the rage. But let’s not forget about an old friend: VBA UDFs (User Defined Function). Continue reading
Auditing & Editing M code (Power Query)
Power Query is a powerful and intriguing tool. However, there are stumbling blocks that make it challenging. Let’s audit and then modify some M code! Continue reading
All Combinations Using Power Query
Given 3 separate lists of text how can we create all combinations? I’ve known Power Query (Get & Transform) can create a cartesian product but it’s only now that it’s part of my active skill set. 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
Power Query solution: partial match count with a condition
In a previous post we saw how formulas can solve a partial match with conditions. Now I will solve it using Power Query because my friend Kunle challenged me to do so 🙂 Continue reading
Sorted Data Validation List
This post from ExcelFORO explains how to use VBA to create a sorted data validation list. It’s a great solution! Are there other ways to solve this? Continue reading
Weighted Average
I’ll show you the weighted average formula, how it calculates, and I’ll prove that the answer is correct! Continue reading
CAGR in Microsoft Excel
Recently I was asked “How can you prove that the CAGR answer is correct?“. In this post I’ll show you how to verify the CAGR result. I’ll also review CAGR basics and pitfalls. Continue reading
Extract Largest Number (Power Query & Flash Fill solutions)
In a recent post I audited my colleague’s amazing array formula. It extracted the largest number from as420lkjs09nsdk2324lkjsd099 See other solutions suggested by YouTube viewers! Continue reading