Hi All -
I have a range of cells in a row that have multiple words in each. I am trying to use a formula that will parse through the range of cells and identify key words and classify the range into a new category.
I have tried both =IF(COUNTIFS(E1:K1, "keyword", "keyword 2", "keyword 3"), "Classification", 0) and =IF(SUM(COUNTIF(E1:K1,{"keyword","keyword 2","keyword 3"})),"Classification", 0)
I was working off of this previous post http://www.excelforum.com/excel-gene...53#post3419053
Bookmarks