I enjoy Kakuro puzzles. They are challenging and rewarding. In this post I’ll explain:
Continue readingWord Game in Excel
It’s not exactly the same as Wordle but close enough 🙂
Continue reading3D Objects
I heard about 3D Objects from MrExcel. I’ve had fun combing a 3D model with VBA (it moves inside your spreadsheet!)
Continue readingRounding 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