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

# Auditing

FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! (more…)

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.**

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

**=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. (more…)

Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. (more…)