My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → Formulas

Word Game in Excel

posted in Formulas, Macros (vba) on April 24, 2022 by Kevin Lehrbass 6 Comments

It’s not exactly the same as Wordle but close enough 🙂

Continue reading →

Rounding with a twist

posted in Formulas on December 13, 2021 by Kevin Lehrbass 0 Comments

Earlier this week I saw an interesting rounding question on the famous MrExcel Forum. And there was a twist!

Continue reading →

DSUM gymnastics

posted in Formulas, Free Data on August 8, 2021 by Kevin Lehrbass 0 Comments

I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading →

CELL Function Adventure

posted in Formulas, Free Data on July 29, 2021 by Kevin Lehrbass 2 Comments

You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! Continue reading →

Flirting with Volatility

posted in Formulas on July 4, 2021 by Kevin Lehrbass 0 Comments

I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. Continue reading →

Calculate Hours from Messy Text

posted in Formulas on May 29, 2021 by Kevin Lehrbass 3 Comments

I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ Continue reading →

aggregating text part 2

posted in Formulas, Get & Transform on April 8, 2021 by Kevin Lehrbass 2 Comments

Haven’t I done this before? It was almost identical except for two details. Continue reading →

How many unique List 1 names found in List 2?

posted in Challenges, Formulas, Get & Transform on May 29, 2019 by Kevin Lehrbass 3 Comments

Imagine two lists of names. We have three questions: (1)how many unique names in List 1? (2)how many unique names in List 2? (3)how many unique names from List 1 are found in List 2?  Continue reading →

CAGR in Microsoft Excel

posted in Formulas on April 3, 2019 by Kevin Lehrbass 0 Comments

Recently I was asked “How can you prove that the CAGR answer is correct?“. In this post I’ll show you how to verify the CAGR result. I’ll also review CAGR basics and pitfalls. Continue reading →

Video 00172 Unique Values for Data Validation Drop Down

posted in Formulas on January 17, 2018 by Kevin Lehrbass 3 Comments

We need to extract unique values from a list to be used in a data validation drop down list. There are many ways to solve this. The best solution depends on asking the right questions. Continue reading →

← Older posts