Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text import all in one column. how do I set it to multiple column | New Users to Excel | |||
help parsing multiple text sets from one cell | Excel Worksheet Functions | |||
Count Text Values in Column | Excel Discussion (Misc queries) | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) |