parsing text in a multiple column count
 

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?


--
JK57
------------------------------------------------------------------------
JK57's Profile: http://www.excelforum.com/member.php...o&userid=33430
View this thread: http://www.excelforum.com/showthread...hreadid=532481

parsing text in a multiple column count
 

=SUMPRODUCT((A2:A100="Jones")*(ISNUMBER(FIND("sb", B2:B100))))


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532481

parsing text in a multiple column count
 

Thanks for the help.


--
JK57
------------------------------------------------------------------------
JK57's Profile: http://www.excelforum.com/member.php...o&userid=33430
View this thread: http://www.excelforum.com/showthread...hreadid=532481

parsing text in a multiple column count
 

Glad it helped


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=532481