I've created two separate IF statements using ISNUMBER(SEARCH to replace the custom filter function to target a specific type of work. Only problem is that it requires two separate columns. I'd like to combine into one column using the OR fuction. I've tried this numerous times/ways and can't seem to get it to work. What am I doing wrong? See the attached workbook, which I think is self explanatory. Help from a guru would be much appreciated!
Try this
Please Login or Register to view this content.
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
Or use * in between VBMS can easy found, rather than fix criteria like "VBMS;D" / ";VBMS"Please Login or Register to view this content.
eg: abc VBMS, VBMS zzz, AAAVBMS, VBMSxyz, will return true as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks