I heard about 3D Objects from MrExcel. I’ve had fun combing a 3D model with VBA (it moves inside your spreadsheet!)
Continue reading3D Objects
Author Archives → Kevin Lehrbass
Rounding with a twist
Earlier this week I saw an interesting rounding question on the famous MrExcel Forum. And there was a twist!
Continue readingS curve
I played around with two different S curve concepts using dynamic arrays.
Continue readingZen Mode
https://lichess.org/ has a Zen mode. Can I create a Zen mode in Excel to celebrate Spreadsheet Day?
DSUM gymnastics
I explored ideas to make DSUM function’s criteria argument as flexible as a gymnast. Is it a spreadsheet miracle? Maybe. Continue reading
CELL Function Adventure
You may never need this…but I did recently and it’s just fun knowing that Excel can solve this! Continue reading
Flirting with Volatility
I had some questions and improvement ideas for my formula pixel face. I learned a lot playing around with this. Continue reading
Calculate Hours from Messy Text using Power Query
Daniel Choi solved it using Power Query! Let’s review his solutions. Continue reading
Calculate Hours from Messy Text
I need to calculate hours given data like this in each cell: “9-10, 10-11, 10-11, 12-13, 12-15+, 14-17+“ Continue reading
aggregating text part 2
Haven’t I done this before? It was almost identical except for two details. Continue reading