In the movie Forrest Gump I’m sure you remember when Bubba lists different ways to prepare shrimp: “You can barbecue it, boil it, broil it, bake it, saute it. Dey’s uh, shrimp-kabobs, shrimp creole, shrimp gumbo. Pan fried, deep fried, stir-fried. There’s pineapple shrimp, lemon shrimp, coconut shrimp, pepper shrimp, shrimp soup, shrimp stew, shrimp salad, shrimp and potatoes, shrimp burger, shrimp sandwich. That- that’s about it.“ Continue reading
Date Archives → 2016
Video 00153 All Possible Pairs from List of Names
Oz du Soleil and I have been trading Excel ideas for a couple of years now. During ModelOff’s Global Training Camp in Toronto (Sept 22&23) I met Oz in person! Oz flew in from Oregon to deliver one of the Excel sessions. At one point Oz asked the following question: “Given a list of 10 names, how can Excel display all the name pairs?” Continue reading
Liam Bastick from sumproduct.com
I recently presented at ModelOff’s Global Training Camp in Toronto. One of the many great things about the training camp was that I had the pleasure of meeting Excel guru Liam Bastick. Continue reading
How Many Unique Visitors To Site Each Day?
Such a clear question originating from the classic: “How many unique items per group“? Continue reading
Extracting Data That Could Be Anywhere In Any Sheet
This post from Tom Urtis reminded me of a crazy Excel puzzle I once solved. The concept was similar except for one tiny twist! First of all, let’s review the original puzzle from Tom: Continue reading
Re-arrange, Rotate, Transpose, Twist, Cascade the data!
Who knows what could happen in the future but for now humans using software cleanup and analyze data (not nerdy robots!). This post reviews examples of awkwardly twisted data that require transposing, rotating, repeating, etc before it can be properly analyzed.
Video 00151 Custom Formats, VBA, and Nerds!
I doubt that you have ever seen custom formats presented like this before! Selecting a name from a drop down list changes the custom format and also displays a nerd! Continue reading
Otis Can’t Find a Date!
Otis is looking for a date but he can’t find it! Let’s review four solutions that help Otis find a date. Continue reading
Video 00150 Sequential Keyword Search Dog Chases Squirrel
Extracting insights from text can get messy! The good news is that challenging requirements can often lead to very creative solutions! Continue reading
Video 00149 Alphabetize Challenge (Oz001)
Excel MVP Oz Du Soleil contacted me a few days ago with an interesting Excel challenge: “how could Excel alphabetize titles, but ignore A, An or The if a title begins with one of those?” Continue reading