How To Search For Multiple Words With "Find"

%3CLINGO-SUB%20id%3D%22lingo-sub-3280958%22%20slang%3D%22en-US%22%3EHow%20To%20Search%20For%20Multiple%20Words%20With%20%22Find%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3280958%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20Excel%20Sheet%20is%20my%20bank%20statement%2C%20so%20I%20cant%20share%20that%2C%20but%20I%20can%20explain%20well%20enough%20that%20a%20visual%20shouldn't%20be%20needed.%3CBR%20%2F%3EThe%20Data%20is%20only%204%20Columns%20(A-D)%3CBR%20%2F%3E(A)%20Date%26nbsp%3B%20%26nbsp%3B%20%7C%26nbsp%3B%20%26nbsp%3B(B)%20Type%20of%20Transaction%26nbsp%3B%20%26nbsp%3B%20%7C%26nbsp%3B%20%26nbsp%3B%20(C)%20Location%26nbsp%3B%20%26nbsp%3B%20%7C%26nbsp%3B%20%26nbsp%3B%20(D)%20Amount%3CBR%20%2F%3E%3CBR%20%2F%3E(B)%20Also%20stores%20the%20website%2Fphysical%20store%20where%20the%20transaction%20took%20place.%26nbsp%3B%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E-%20I%20want%20to%20simply%20search%20for%20multiple%20keywords%20instead%20individually%20searching%201%20word%20at%20a%20time.%26nbsp%3B%3CBR%20%2F%3ELets%20say%20I%20want%20to%20delete%20all%20Rows%20where%20these%20words%20exist%3A%3CBR%20%2F%3ESonic%3CBR%20%2F%3EeBay%3C%2FP%3E%3CP%3E7%20Eleven%3C%2FP%3E%3CP%3EAmazon%3CBR%20%2F%3EApple%3CBR%20%2F%3ENetflix%3CBR%20%2F%3E%3CBR%20%2F%3E~%20Is%20this%20possible%3F%20Basically%20decreasing%20the%20amount%20of%20time%20by%20the%20number%20of%20keywords%20you're%20wanting%20to%20remove.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3280958%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281044%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Search%20For%20Multiple%20Words%20With%20%22Find%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1319002%22%20target%3D%22_blank%22%3E%40RKD2313%3C%2FA%3E%26nbsp%3BPerhaps%20the%20attached%20file%20will%20clarify%20what%20I%20had%20in%20mind.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3281011%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Search%20For%20Multiple%20Words%20With%20%22Find%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3281011%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20your%20example%2C%20using%20%22KeyWords%22%20as%20the%20term%2C%20wouldn't%20this%20just%20result%20in%20finding%20rows%20where%20%22KeyWords%22%20matches%3F%20Im%20not%20sure%20Im%20grasping%20what%20you're%20saying.%20If%20I%20am%20understanding%2C%20even%20somewhat%2C%20%22Keywords%22%20is%20only%201%20search%20term%3F%20If%20I%20have%20500%20Rows%20of%20the%20best%20fast%20food%20chains%20in%20USA%20State%20by%20State%20and%20I%20want%20to%20rid%20all%20rows%20containing%20%22Burger%20King%22%20%22McDonalds%22%20%22Sonic%22%20%22Arbys%22%20%22Subway%22%20%22Chilis%22%20etc%20etc%2C%20but%20these%20keywords%20are%20randomly%20placed%20throughout%20those%20500%20Rows%2C%20how%20can%20I%20search%20for%20all%20of%20those%20keywords%20%2B%20Delete%20Rows%20containing%20mentioned%20restaurants%20in%201%20go%20(If%20thats%20even%20possible).%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20dont%20understand%20you%2C%20but%20you%20understand%20me%2C%20I%20apologize%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3280980%22%20slang%3D%22en-US%22%3ERe%3A%20How%20To%20Search%20For%20Multiple%20Words%20With%20%22Find%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3280980%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1319002%22%20target%3D%22_blank%22%3E%40RKD2313%3C%2FA%3E%26nbsp%3BBegin%20by%20assigning%20a%20name%20to%20the%20range%20that%20contains%20the%20keywords%2C%20for%20example%20%22KeyWords%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20in%20E2%20enter%20this%20formula%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DIFERROR(INDEX(KeyWords%2CMATCH(TRUE%2C(ISNUMBER(SEARCH(KeyWords%2CB2%2C1)))%2C0)%2C1)%2C%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3Eand%20copy%20it%20down.%20It%20should%20return%20the%20%3CU%3Efirst%3C%2FU%3E%20keyword%20found%20in%20the%20text%20in%20column%20B%20if%20it%20finds%20at%20least%20one%20of%20the%20keywords.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

The Excel Sheet is my bank statement, so I cant share that, but I can explain well enough that a visual shouldn't be needed.
The Data is only 4 Columns (A-D)
(A) Date    |   (B) Type of Transaction    |    (C) Location    |    (D) Amount

(B) Also stores the website/physical store where the transaction took place.  

- I want to simply search for multiple keywords instead individually searching 1 word at a time. 
Lets say I want to delete all Rows where these words exist:
Sonic
eBay

7 Eleven

Amazon
Apple
Netflix

~ Is this possible? Basically decreasing the amount of time by the number of keywords you're wanting to remove. 

3 Replies

@RKD2313 Begin by assigning a name to the range that contains the keywords, for example "KeyWords".

 

Then in E2 enter this formula:

=IFERROR(INDEX(KeyWords,MATCH(TRUE,(ISNUMBER(SEARCH(KeyWords,B2,1))),0),1),"")

and copy it down. It should return the first keyword found in the text in column B if it finds at least one of the keywords.

In your example, using "KeyWords" as the term, wouldn't this just result in finding rows where "KeyWords" matches? Im not sure Im grasping what you're saying. If I am understanding, even somewhat, "Keywords" is only 1 search term? If I have 500 Rows of the best fast food chains in USA State by State and I want to rid all rows containing "Burger King" "McDonalds" "Sonic" "Arbys" "Subway" "Chilis" etc etc, but these keywords are randomly placed throughout those 500 Rows, how can I search for all of those keywords + Delete Rows containing mentioned restaurants in 1 go (If thats even possible).

If I dont understand you, but you understand me, I apologize

@RKD2313 Perhaps the attached file will clarify what I had in mind.