It’s not exactly the same as Wordle but close enough 🙂
Continue readingPost Category → Videos
3D 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 readingDSUM 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
whack-a-merged-cell
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! Continue reading