| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare a column of substring with another column of strings and get count | Excel Discussion (Misc queries) | |||
| compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
| compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
| How do I compare string values in one column to another column? | Excel Worksheet Functions | |||
| Compare one Column to a Second Column Formula Help Needed | Excel Worksheet Functions | |||
Linear Mode
