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

# Author: Kevin Lehrbass

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

I’ll show you the weighted average formula, how it calculates, and I’ll prove that the answer is correct! (more…)

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

So many times vlookup (or index & match) saves the day and gets your answer! ….wait…are you sure it’s correct??? Read this post to see why you should use countifs to confirm your vlookup. (more…)

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

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

- BY Kevin Lehrbass
- POSTED IN Challenges, Get & Transform
- WITH 6 COMMENTS
- PERMALINK
- STANDARD POST TYPE

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

I saw Chandeep’s **Data Cleanup Challenge** and it looked like fun. Others solved it using Power Query (some amazing solutions) but I used good ol’ fashioned formulas! (more…)

- BY Kevin Lehrbass
- POSTED IN Auditing, Formula or VBA
- WITH 6 COMMENTS
- PERMALINK
- STANDARD POST TYPE

A work colleague shared this challenge: extract the largest number from this text **as420lkjs09nsdk2324lkjsd099** ! The answer is **2324**. How do we solve this? Formulas? VBA? (more…)

- BY Kevin Lehrbass
- POSTED IN Macros (vba)
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE

**How can you improve your VBA skills?** **Build something!** **Anything!** Even if it’s ridiculous. I needed to practice and ended up creating a robot and a bunch of random style hearts! 🙂 (more…)

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

Before you analyze your data it’s important to decide if you need to unpivot it. Why unpivot? What’s unpivot? Are there exceptions? (more…)

- BY Kevin Lehrbass
- POSTED IN Get & Transform, Tips
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE

Rearranging data is initially about recognizing the pattern. This screenshot is from Ken Puls. I instantly saw the steps to rearrange the data (thanks to Ken’s **online course**!) (more…)