I'm completely new to excel, so I apologize if this is a silly question, but I'm really stuck. I have to search for a list of street names in an excel document every week, and I've been doing it manually and its killing me. Basically there are 200 rows of data and I need to be able to find any row that contains a list of 50 or so street names and remove them. Is there any way for me to search the document and find the street names?
Thank you!
With
A1: containing a string...
Examples:
This is my baseball
Those are your baseballs
What is a base ball
A frisbee is not a base ball
and this list in C1:C2
baseball
frisbee
These regular formulas return TRUE if the referenced cell contains any of the list words
For the above example, these are the results:
B1: =ISNUMBER(LOOKUP(10^10,SEARCH(" "&$C$1:$C$2&" "," "&A1&" ")))
Is that something you can work with?This is my baseball TRUE Those are your baseballs FALSE What is a base ball FALSE A frisbee is not a base ball TRUE
Thank you Ron, that worked perfectly!
Glad you got something you can use!
Please be sure to mark this thread as SOLVED (from the Thread Tools menu)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks