My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Post Category → Formula or VBA

Robert Gascon’s Shortest Formula Challenge

posted in Challenges, Formula or VBA on October 14, 2020 by Kevin Lehrbass 8 Comments

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

Awkward Data

posted in Formula or VBA on July 26, 2020 by Kevin Lehrbass 3 Comments

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

posted in Formula or VBA, Tips on April 22, 2019 by Kevin Lehrbass 3 Comments

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

posted in Auditing, Formula or VBA on March 3, 2019 by Kevin Lehrbass 13 Comments

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?

posted in Formula or VBA on July 25, 2018 by Kevin Lehrbass 0 Comments

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?

posted in Formula or VBA on February 24, 2016 by Kevin Lehrbass 2 Comments

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 →