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!
Bookmarks