Compare a column of substring with another column of strings and get count
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 |
All times are GMT +1. The time now is 02:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com