# Rounding with a twist

Earlier this week I saw an interesting rounding question on the famous MrExcel Forum. And there was a twist!

# DSUM gymnastics

I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading

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

# 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

# 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

# Video 00172 Unique Values for Data Validation Drop Down

We need to extract unique values from a list to be used in a data validation drop down list. There are many ways to solve this. The best solution depends on asking the right questions. Continue reading