For Mr Excel’s recent challenge I decided to go with an old school formula helper column solution. Why? I’ll explain. Continue reading
Date Archives → 2020
Kevin’s Formula Challenge
My friend Robert Gascon was thinking about Excel formula challenges and Kentucky Fried Chicken (he loves KFC) while drinking a beer. Continue reading
Wayne Gretzky’s Goals
Let’s explore Wayne Gretzky’s goals (it’s his birthday tomorrow!). I’ve thought of some good questions and one “great” question that we can answer using this dataset. Finally, could Ovechkin break Gretzky’s goal record? Continue reading
Power Query Challenge – What Did They Order from the Menu?
Alan Murray (Computergaga) had an interesting challenge on YouTube. It’s a classic case of “Analyze my awkward dataset!”. He solved it using Power Query. Can it be solved using formulas? Continue reading
use vba to name checkboxes
Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas.
Continue reading