Counting and Frequency of String values question.

In column A I have a range of about 4000 string values. (example. abc1231a, abc1231b, etc.). There are duplicates in column a.

In column B I have another range of values (1a, 1b, etc.), with no duplicates.

Column A contains longer strings that contain the values in column B. A value in column A will never be an exact match to a value in Column B and there is no uniform delimiter.

I want to count the frequency that each value in Column B appears in the range of Column A, and display it in column C.

Any help would be appreciated!

Originally Posted by NBVC

Are you looking for unique counts.. i.e. if there are 2 abc1231a entries does it count as 1 or 2?

It would count as two.

example:

Column A

abc1231a
abc1231b
abc1251a
wedweqx1c


Column B

1a
1b
1c
1d



Column C (desired count)

2
1
1
0

because 1d was found nowhere in the values of column A

Thank you, that did the trick.

To take that one step further, is there any way to count the occurrence of those substrings and make sure to get a count of only an exact match, ie. When I count '1a' , I don't also want it do count instances of '11a'

Thanks!