Count how many words from a list appear in a cell
To fix the issue you can do If you have the correct words in a list, one
word per cell, e.g in Z2:Z20 with no blanks then you could use this formula
in B1 copied down=SUMPRODUCT(ISNUMBER(SEARCH(" "Z$2:Z$20","," "A1","))+0)
Date : November 21 2020, 07:31 AM , By : Nick D.