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