Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading

# Post Category → Formula or VBA

# Awkward Data

Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading

# Partial Match Count with a Condition

Once again I discovered a formula that I had written down in a notebook. What is it doing? ** Is there an easier way to solve this?** Continue reading

# 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

# formula or vba to add spaces?

Add a space after each character in a cell. Excel expert Tom Urtis solved it with vba. I solved it using a formula. Let’s compare these methods. Continue reading

# Formulas or VBA to create military code?

**How do you know whether you should use Excel Formulas or Excel VBA?** Sometimes both work and sometimes only one works. This series will explore this question. Let’s start with an idea from Sumit Bansal at **TrumpExcel**. Continue reading