29
Jul 2021
- BY Kevin Lehrbass
- POSTED IN Formulas, Free Data
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! (more…)
Author: Kevin Lehrbass
04
Jul 2021
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. (more…)
30
May 2021
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Daniel Choi solved it using Power Query! Let’s review his solutions. (more…)
29
May 2021
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ (more…)
08
Apr 2021
- BY Kevin Lehrbass
- POSTED IN Formulas, Get & Transform
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Haven’t I done this before? It was almost identical except for two details. (more…)
07
Feb 2021
- BY Kevin Lehrbass
- POSTED IN Reviews, T_Education
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I was working on a demo file about Excel’s new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! (more…)
23
Jan 2021
- BY Kevin Lehrbass
- POSTED IN Reviews
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Let’s forget 2020 but I will review my posts. Thanks Excel for helping me through the year. (more…)
23
Nov 2020
- BY Kevin Lehrbass
- POSTED IN Macros (vba)
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! (more…)
14
Oct 2020
- BY Kevin Lehrbass
- POSTED IN Challenges, Formula or VBA
- WITH 8 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! (more…)
29
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Solutions
- WITH 3 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?
Do You Excel?
