Forum Discussion
NathanJB665
Nov 22, 2021Copper Contributor
Identifying Keywords in a Long List of Descriptions Shortcut
Hi everyone, I have 101,000 descriptions. I am searching for keywords within these descriptions to narrow down a target list. I have 147 keywords I would like to search for. Column one contains the n...
Riny_van_Eekelen
Nov 22, 2021Platinum Contributor
NathanJB665 Perhaps Power Query is more suited for such a data set. I attached a small demo. Have you used PQ before?
Test it by expanding the table on the left with some of your own descriptions and the one on the right with real keywords. But don't change the column headers or table names. Now, from the Data ribbon select Refresh All. Does it work for you?