Countif multiple criteria in text string

p45cal · #1 06-29-2024, 07:25 AM

In cell D2:

Code:

=LET(x,IF(SEARCH(Words[Word],C2),Words[Type]),TAKE(FILTER(x,NOT(ISERR(x)),""),1))

Copy down.

2024-06-29_152139.jpg

I made a table of the words you're looking for and what type of case they're related to.
This table needs to be in the order so that when a comment contains 2 or more words you're looking for, the type of case you want to see as a preference comes above the others. You can add/delete rows from this table without needing to adjust the formulae.
See attached.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with multiple criteria	Marcia	Excel	5	02-17-2019 08:16 AM
COUNTIF [criteria] + give %	Tomas4	Excel	2	12-20-2016 10:28 AM
Sum Product Multiple Text and date Criteria	ramki	Excel	1	01-09-2012 01:16 AM
using a cell content as a string with COUNTIF	geoffm	Excel	1	08-16-2011 11:31 AM
Countif with 2 criteria	ibrahimaa	Excel	3	05-23-2011 11:23 AM