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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Compare a column of substring with another column of strings and get count
Shanmu has brought this to us :
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 The COUNTIF() function is what you need, and usage can be found under the Function Reference in online help. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
|
|||
|
|||
Quote:
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 |
#4
|
|||
|
|||
Quote:
Excellent Prashant... It works. Thanks :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
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 |