I watched the closing ceremonies of the Olympics last night. It was very nice…but who won the Olympics? Continue reading
Date Archives → February 2018
Rouge National Urban Park
My wife and I recently visited Rouge National Urban Park. We wanted to spend some time away from TV, internet and Excel. We did…but I discovered some data in the Park! Continue reading
Dynamic Hyperlinks in Excel to HockeyDB
About 16 years ago I discovered HOCKEYDB. I was hooked! Why? Growing up in the late 70s and 80s I was a huge hockey fan but without cable or the internet information was limited. I had so many unanswered questions. Continue reading
Chandoo’s Sequence Number Puzzle
I saw this sequencing challenge from Chandoo “Generate a new sequence number when value changes“. His formula solution is great but I kept thinking “What if we have 20000 rows?“ Continue reading
Rank within Groups in Excel
How can we rank within groups in Excel? Most experts will tell you to use the SUMPRODUCT function. Why? It’s the only solution they know or maybe they’re concerned about compatibility. Is anyone still using Excel 2003? Let’s compare SUMPRODUCT and COUNTIFS. Continue reading
Video 00173 Dynamically Combine Data From Excel Tables
An ounce of prevention is worth a pound of cure but how does this apply to Microsoft Excel? In this post I will show you a common example. Too late for prevention? I’ll show you two solutions. Continue reading