Forum Discussion
Find a list of words in multiple columns
Hi, please, I use this formula in Excel to find out which cells contain certain text: =IF(COUNT(SEARCH({"white","blue","red","black"},B1)),"Yes","") As you can see, the formula looks for text in ce...
Try this formula:
=IF(SUM(COUNTIF(A1:Q1,{"*white*","*blue*","*red*","*black*"})),"Yes","")
In addition to the actually best solution that Mr.Hans Vogelaar (@Hans Vogelaar) offered you, this information. But could also use Mr. Hans Vogelaar (@Hans Vogelaar) formula, just need to set the area to a specific cell.
Check if a cell contains text (case-insensitive)
Nikolino
I know I don't know anything (Socrates)
