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

Once again I discovered a formula that I had written down in a notebook. What is it doing? ** Is there an easier way to solve this?** (more…)

22
Apr 2019

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

** Is there an easier way to solve this?** (more…)

16
Apr 2019

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

09
Apr 2019

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

09
Apr 2019

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

03
Apr 2019

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

** 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…)

26
Mar 2019

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

21
Mar 2019

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

**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…)

03
Mar 2019

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

**as420lkjs09nsdk2324lkjsd099** ! The answer is **2324**. How do we solve this? Formulas? VBA? (more…)

12
Feb 2019

- 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…)

08
Feb 2019

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