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
Calculate Hours from Messy Text
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
whack-a-merged-cell
Do merged cells irritate you? My latest lame game gives you points for whacking merged cells! Continue reading
Robert Gascon’s Shortest Formula Challenge
Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading
Aggregating Text
Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?
awkward-data/power-query-solution
My last post was about an awkward dataset. Now I’ll review Daniel Choi’s Power Query solution that rearranges the data. Continue reading
Awkward Data
Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading
Add color to letters inside a cell
VBA can color certain characters within a cell. It was fun to practice vba and build this but it doesn’t work well with many rows of text. Continue reading