I have a catalog of reports that I want to search in, the list is thousands of rows long, the titles of the reports are one long text string in a column, I want to find all reports where "50" is in the title of the report and "engineering" is also in the title of the report ... is there a way to do this?? Looking at FIND function options doesn't appear to be a way ...
Hi
I'd use an = IF(ISERROR(MATCH("*50*,A:A,False),"Not Found") in one column adjacent to your strings, and =ISERROR(MATCH("*engineering*",A:A,False),"Not Found") in in another.
Copy these down and then filter the columns for values that don't have Not Found.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
error.png
I get some kind of error message trying to copy in your first formula, notice how it's highlighting "Not
Not what you asked for but a macro like this could do it:
Or perhaps somebody with more know how than me could write this as an UDF?
Please Login or Register to view this content.
By the way the command InStr is case sensetive so a combination of "Engineering" and "50" will not be taken as a match.
Alf
Last edited by Alf; 01-09-2015 at 04:43 PM. Reason: additional information
These could work for you. This has the titles in column A starting at A2 use this in column B (or column of your choice) and fill down:
Formula:
Please Login or Register to view this content.
If you want to be able to enter different terms in say cells D1 and E1 use this in column B (or column of your choice) and fill down:
Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks