| 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) | |||
Hybrid Mode
