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

Continue reading# Post Category → Formulas

# 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

# 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

# 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

# Video 00081 Count and find different types of Excel errors

**Have you ever inherited a messy Excel file?**

It can be * REALLY *painful! Over the years I have used various techniques to audit Excel files.

This post shows you how to distinguish between different error types, count them and find them!