I played around with two different S curve concepts using dynamic arrays.

Continue reading# 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