Forum Discussion
Search for many words in a cell and return exactly the same words if they exist
Hello, I hope you are all well. I want to search about 50,000 words or phrases in one column. If there are any number of these words, I want the exact same words to be returned to me in the opposite ...
Re: Extract Certain Words
This is a much different approach.
It used the free workbook "Professional_Compare" which has multiple utilities
including "List All Words".
It lists all of the words from multiple cells, with the count, in a separate sheet.
The example used 50,000 cells with three words in each cell...
List of words (truncated)...
Separate List of Extracted Words - listed in order by count (truncated)...
(just a few seconds required to generate the list)
Download 'Professional_Compare' from OneDrive...
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
'---
Nothing Left to Lose