parsing text in a multiple column count

J

JK57

I have one column (A) that is a list of names and a second column (B)
that is a list of text strings. I need to count the number of
instances a name (say "Jones") in column A correlates with a specific
portion of the text in column B (say the "sb" within the text "-2p2sb"
- in other words, I need to search column B for a substring and hook
that with data in column A. The substring I'm interested in can occur
at inconsistent postions within the text in column B. How done?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with the error: unable to filter on excel hc home school 0
How to center adjust text above and image in a two column document. 1
Setting column width in a table with a macro is not working 0
Formating bolded text exclusively. 0
Change a great number of words in word files, with a macro as short as possible. 5
Excel does not accept text format! 0
Need help finding a substring in a array of strings. 1
Count Column B if Column A is within a multiple specificed ranges 2

Top