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
Liam Bastick from sumproduct.com
Author Archives → Kevin Lehrbass
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
Video 00147 Conditionally Add Checkboxes using VBA
I often use check-boxes in my Excel videos to explain the solution steps. Creating them can be tedious so I thought that there had to be an easier way. Continue reading
Video 00148 Insert Rows & Cascade Numbers
Our task is to repeat each original row three times and then cascade each original number diagonally down to the right. Continue reading