- BY Kevin Lehrbass
- POSTED IN Efficiency
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

# Author: Kevin Lehrbass

- BY Kevin Lehrbass
- POSTED IN Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**How can we rank within groups in Excel?** Most experts will tell you to use the SUMPRODUCT function. Why? It’s the only solution they know or maybe they’re concerned about compatibility. Is anyone still using Excel 2003? Let’s compare SUMPRODUCT and COUNTIFS. (more…)

- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**An ounce of prevention is worth a pound of cure** but **how does this apply to Microsoft Excel?** In this post I will show you a common example. Too late for prevention? I’ll show you two solutions. (more…)

- BY Kevin Lehrbass
- POSTED IN Gurus, Solutions
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

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. (more…)

- BY Kevin Lehrbass
- POSTED IN Auditing, Gurus
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE

- BY Kevin Lehrbass
- POSTED IN Efficiency
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

Some Excel models have so many complex formulas that they just can’t calculate any more. These models often need to be re-created. Some models can be saved by making formulas more efficient. One technique is to **add an OFF SWITCH to heavy formulas**. (more…)

- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE

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. (more…)

- BY Kevin Lehrbass
- POSTED IN Solutions
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**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. (more…)

- BY Kevin Lehrbass
- POSTED IN The EXCEL Path
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**Do you want to become a Microsoft Excel master?** The first step might be to convince yourself that it’s possible (it is!). Then, you need some good material and determination! (more…)

- BY Kevin Lehrbass
- POSTED IN Reviews
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

Stand-up mathematician **Matt Parker** did a comedy routine about spreadsheets. Hmm….why not create a post about this? How can I make it interesting? My quest to find an interesting angle led me to….well…creating a YouTube Transcript spreadsheeet! (more…)