It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. Continue reading

# Post Category → Auditing

# Old School Helper Columns

For Mr Excel’s recent challenge I decided to go with an old school formula helper column solution. Why? I’ll explain. Continue reading

# Chess FEN viewer

FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! Continue reading

# Humidex Formula in Excel

In Canada we have long harsh winters but July was REALLY hot this year! How hot? **Let’s combine heat & humidity to determine the real temperature we feel.**

# Largest Number Inside Alphanumeric String

A friend shared this challenge: extract the largest number from this text **as420lkjs09nsdk2324lkjsd099** ! The answer is **2324**. How do we solve this? Formulas? VBA? Continue reading

# What is this formula doing?

**=SUMPRODUCT(MID(G2,{1;2;3},1)*1)** I found this formula in a notebook. Can you understand it’s purpose? I’ll explain it in this post. I’ll also expand it for a more complex case. Continue reading

# Change Text to Sentence Case

As Puneet Gogia mentions in his **post**, we can change text using UPPER, LOWER and PROPER functions but **we don’t have a SENTENCE function to capitalize the first letter of each sentence**. Puneet solves it with a very interesting formula. **How exactly does it work? Let’s audit it!** Continue reading

# Video 00141 Formula Auditing Maestro

Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. Continue reading