Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! (more…)
Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?
Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? (more…)
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. (more…)
It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. (more…)
Let’s take a look at something that’s SO easy to calculate today with a simple spreadsheet but was very challenging to calculate in the past. (more…)
Excel is not meant to store historical data. That’s what databases do. However, Tom Urtis shows us a trick to keep the all time min value from a single input cell. (more…)
I keep hearing “flatten the curve” during these uncertain times of covid-19. What’s that? What do we do? Also, what can we do to reduce anxiety? For me I decided to create a “flatten the curve” demo in Excel and in Power BI 🙂 (more…)
For Mr Excel’s recent challenge I decided to go with an old school formula helper column solution. Why? I’ll explain. (more…)
