My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → Auditing

Calculate Wind Chill in Excel

posted in Auditing on April 21, 2020 by Kevin Lehrbass 10 Comments

It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. Continue reading →

Old School Helper Columns

posted in Auditing, Challenges on March 6, 2020 by Kevin Lehrbass 0 Comments

For Mr Excel’s recent challenge I decided to go with an old school formula helper column solution. Why? I’ll explain. Continue reading →

Chess FEN viewer

posted in Auditing, Other on August 23, 2019 by Kevin Lehrbass 3 Comments

FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! Continue reading →

Humidex Formula in Excel

posted in Auditing on August 10, 2019 by Kevin Lehrbass 3 Comments

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.

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 →

What is this formula doing?

posted in Auditing on January 13, 2019 by Kevin Lehrbass 9 Comments

=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. Continue reading →

Change Text to Sentence Case

posted in Auditing, Gurus on January 26, 2018 by Kevin Lehrbass 5 Comments

As Puneet Gogia mentions in his post, we can change text using UPPER, LOWER and PROPER functions but we don’t have a SENTENCE function to capitalize the first letter of each sentence. Puneet solves it with a very interesting formula. How exactly does it work? Let’s audit it! Continue reading →

Video 00141 Formula Auditing Maestro

posted in Auditing on January 14, 2016 by Kevin Lehrbass 0 Comments

Some formulas are complex due to a complex question. Other formulas are complex due to inefficient data layout. Continue reading →