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

# Auditing

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