Thread: Compare a column of substring with another column of strings and get count
View Single Post
  #2   Report Post  
jack_n_bub jack_n_bub is offline
Member
  
Location: Bangalore
Posts: 41
Thumbs up
Quote:
Originally Posted by Shanmu View Post
Below is the scenario. I have 2 columns. Column A has some article Ids (IS123, IS1234, etc.). Column X has Solutions provided to customer, where this article Id would be a reference (substring.)

I need the to compare each article Id (column A) with all solutions provided (Column X) and get the count of occurrences of each article Id in Column B.

Please Help!!

-Shanmu
Hi,

Try this...

=COUNTIF(B2:B4,"*"&A2&"*")

As per your scenario the ID is in cell A2 and the searched text is in the B2:B4 range. You may change references as per your use.

Let me know if it works.

Thanks,
Prashant
Reply With QuoteReply With Quote