My Spreadsheet Lab

The site is about Microsoft Excel.

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

Post Category → Solutions

Aggregating Text

posted in Solutions on August 29, 2020 by Kevin Lehrbass 3 Comments

Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?

Continue reading →

Sorted Data Validation List

posted in Solutions, Tips on April 16, 2019 by Kevin Lehrbass 6 Comments

This post from ExcelFORO explains how to use VBA to create a sorted data validation list. It’s a great solution! Are there other ways to solve this? Continue reading →

Weighted Average

posted in Solutions, Tips on April 9, 2019 by Kevin Lehrbass 0 Comments

I’ll show you the weighted average formula, how it calculates, and I’ll prove that the answer is correct! Continue reading →

Retrieve 1st Code for Selected City When Description is not blank

posted in Solutions on May 16, 2018 by Kevin Lehrbass 5 Comments

In Microsoft Excel there are often many different ways to create a solution. The best solution is often subjective based on whether we emphasize simplicity or efficiency. Here is a good example: Continue reading →

Variable Sized Groups Within Each Column

posted in Solutions on May 7, 2018 by Kevin Lehrbass 0 Comments

Every once in a while we get a unique challenge in Excel. This one required some creativity to quickly create a solution due to a pending deadline.
Continue reading →

Video 00174 Ranking Values into Tiers in Excel

posted in Gurus, Solutions on January 29, 2018 by Kevin Lehrbass 0 Comments

Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution. Continue reading →

Video 00158 Keyword Data Validation List

posted in Solutions on January 13, 2018 by Kevin Lehrbass 0 Comments

Is your data validation list is so long that the endless scrolling makes you want to close Excel and never use it again? This post will review several solutions to this problem. Continue reading →

Video 00171 Create Christmas Lights Using Excel Sheets

posted in Solutions on January 5, 2018 by Kevin Lehrbass 2 Comments

Did you know that an Excel UDF can change the color of a sheet tab? David Hager’s post shows us how to do this! Somehow I came up with the idea to create Christmas Lights using Excel sheet tabs! Continue reading →

Video 00167 Sliding Formula Ranges

posted in Solutions on November 8, 2017 by Kevin Lehrbass 0 Comments

Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your analysis. This post contains three examples in which normalizing your data might not be necessary when doing a quick analysis. Continue reading →

Video 00166 Count Groups Above or Below Targets

posted in Solutions on November 7, 2017 by Kevin Lehrbass 0 Comments

This Excel puzzle almost sounds like it could be solved with a quick COUNTIFS function but it’s a bit more involved than that. Nevertheless, it doesn’t have to get complicated as it can still be solved using a few simple steps. Continue reading →

← Older posts