Forum Discussion
Search for many words in a cell and return exactly the same words.By writing formulas.Not Power Quer
Hello, I hope you are all well. I don't want to do this with Power Query. I want to write with a formula that should probably have a search function in it. I don't want it to be case sensitive. I wa...
You could use:
=BYROW(A2:A9,LAMBDA(row,TEXTJOIN(",",1,XLOOKUP(TEXTSPLIT(row," "),words,words,""))))
I'm a bit surprised PowerQuery is taking long to run on your computer. I don't know if the above will be any quicker but here it is.
Ok, thank you very much. Multiply these numbers and you will understand the size of the project. Ten thousand words should be searched in 20 thousand cells, each level has about ten thousand words. This will be one of my files. I have about forty files. I think your formula is perfect, I will test it. Thank you for your answer