Extracting insights from text can get messy! The good news is that challenging requirements can often lead to very creative solutions! Continue reading
Date Archives → June 2016
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