08
Apr 2021
- BY Kevin Lehrbass
- POSTED IN Formulas, Get & Transform
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Haven’t I done this before? It was almost identical except for two details. (more…)
Author: Kevin Lehrbass
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?
03
Aug 2020
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
26
Jul 2020
- BY Kevin Lehrbass
- POSTED IN Formula or VBA
- WITH 3 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? (more…)
26
Apr 2020
- BY Kevin Lehrbass
- POSTED IN vba
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
VBA can color certain characters within a cell. It was fun to practice vba and build this but it doesn’t work well with many rows of text. (more…)
21
Apr 2020
- BY Kevin Lehrbass
- POSTED IN Auditing
- WITH 8 COMMENTS
- PERMALINK
- STANDARD POST TYPE
It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. (more…)
Do You Excel?
