I played around with two different S curve concepts using dynamic arrays.
Continue readingS curve
Author Archives → Kevin Lehrbass
Zen 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
Discover Data Types templates
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! Continue reading
review of 2020 posts
Let’s forget 2020 but I will review my posts. Thanks Excel for helping me through the year. Continue reading