I actually developed this application for work and for once, it does not contain proprietary information, so I can present it in full here. I am the Excel guru at my company and I present tips to my coworkers. Mostly, these are links back to other sites that explain the concept better than I can. So I developed a spreadsheet that lists the topics and links back to the sites that discuss them. The list grew long and I wanted to give my coworkers a way to search for topics using keywords. So I developed the following.
It is a function that returns TRUE or FALSE based on whether the keyword is found in the string to be searched. The syntax is: KeyWord(StringToSearch,SearchCriteria,AndOrFlag).
The string to search is the first argument. The search criteria is the list of keywords separated by commas. The AndOrFlag is 0 or 1 for OR or AND respectively.
The demo spreadsheet contains real world data and I use a form to "collect" the keywords and some additional VB code to filter and clear data in the table based on a hidden column containing this function.
Please Login or Register to view this content.
Bookmarks