E
EE
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
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