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