Search Engine


January 5th, 2013 by admin admin

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

You must be logged in to post a comment.

s2Member®