Bing Shuen
Reputation: 23
Extract Matching List of Keywords
I have a huge amount of data that has no consistent sentence formatting, and I have a list of keywords I refer to. Whenever a keyword exists in the data, I want to extract them out onto another column. examples of how I want keywords to be extracted I don't mind if it gives "red apple" and "apple"
Currently I'm just using filters to find cells that has the same words, so I can key in extracted keywords as a batch/group
Upvotes: 0
Views: 371
Answers (1)
Harun24hr
Reputation: 36965
Try the following formula-
=BYROW(A2:A4,LAMBDA(x,TEXTJOIN(", ",1,FILTER(F2:F5,COUNTIFS(x,"*"&F2:F5&"*")>0))))
Upvotes: 1
Related Questions
- Excel- How To Find Multiple Matches of Keywords
- Find the list of the keywords from a text and list them in an array in Excel
- Search through hundreds of keywords within column and and output keyword in offset cell
- How to use Python to convert rows to columns in an excel (.xls) file that require the extraction of keywords?
- Extract keywords from Excel or Google spreadsheet column
- Complicated text extract
- Excel - Return value based on list of keywords that match substring
- Extracting rows based on list of target words in a certain column
- Extract the matching word from the list in Excel
- Need help extracting data from excel file