Episode 497 - Finding Substrings

George sends in a question – How can COUNTIF be made to look for cells that match a pattern? Episode 497 shows the long workaround to this problem.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!