All,
Thank you in advance for your help. I am trying to do what I believe is a combo of a COUNT and a CONTAINS function. I would like to compare just one cell to another set of cells and count how many items within the cell being checked are contained in the other cells. An example will help make this more clear.
Cell to check (we shall call it 1) against the references has: A, B, C
Reference cell 2 has: A, D, E
Reference cell 3 has: A, B, C, D
Reference cell 4 has: X, Y, Z
The equation would check to see how many of 1's items (3 total in the example that are text) are in cells 2, 3 and 4. The correct response would be for each as follows:
Cell 2: 1 (A is present here...so it just has one matching...so just 1 as the count)
Cell 3: 3 (All of them from 1 are here...D doesn't matter, as it isn't one of the ones I'm looking for)
Cell 4: 0 (nothing from 1 is present)
Hope this makes sense!
Best wishes,
Scott
Thank you in advance for your help. I am trying to do what I believe is a combo of a COUNT and a CONTAINS function. I would like to compare just one cell to another set of cells and count how many items within the cell being checked are contained in the other cells. An example will help make this more clear.
Cell to check (we shall call it 1) against the references has: A, B, C
Reference cell 2 has: A, D, E
Reference cell 3 has: A, B, C, D
Reference cell 4 has: X, Y, Z
The equation would check to see how many of 1's items (3 total in the example that are text) are in cells 2, 3 and 4. The correct response would be for each as follows:
Cell 2: 1 (A is present here...so it just has one matching...so just 1 as the count)
Cell 3: 3 (All of them from 1 are here...D doesn't matter, as it isn't one of the ones I'm looking for)
Cell 4: 0 (nothing from 1 is present)
Hope this makes sense!
Best wishes,
Scott