This post is written in response to the question posted by someone regarding search engine.  Using a combination of formulas (COUNTIF, INDEX, ROW, ISERROR, SEARCH, SMALL), you can search for key words and have the results returned in another worksheet, just like autofilter except that the results is presented in another worksheet. See the example given.

Leave a Reply