I enjoy the dueling Excel podcasts between Bill Jelen and Mike Girvin! The challenges, the energy, the solutions, the community involvement…everything! Let’s look at Excel duel 141 (the PI episode). The best solution depends on asking one question. Continue reading
As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading
People often ask me questions like these. A quick answer is that array formulas can be used to answer very complex questions about data.
In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading