Hi

I have a column that contains different terms seperated by Comma.
Similar to "Apple, Ball, Cat,Dog, and so on".

I have upto 15 unique values that could be there and different rows
have different number of values. Some rows have no values, some can
have 3 "Apple,Cat,Egg" and some can have 12.

Now I need to find out how many records have a combination of values.
I could have used filter if I I needed two but there may be times I
want to find the number of records that have 9 of the values. (For
example iof these 9 are present in a row that has 12 values, even that
row should be displayed. I am NOT looking for EXACT match.)

Can this be solved using some worksheet functions?

Thanks in Advance

Best
Prasad