Originally Posted by bach
the target utterances, i.e. lines spoken by the child.
Okay check it out. Enter the following in any cell and drag down. Make the modifications I describe below to suit your data ranges.
B$1 is the top cell of the column that holds the child's speech. By that I mean row one of the worksheet, not your data range. Change the letter if your data is in a different column.
$A$3:$A$14 is the range of the tags. "target" is the tag you want to look at. You'd probably replace "target" with "*CHI:" Make sure you include the quotation marks because this tells excel you're specifying a text string and not an actual command of any kind.
1000000 is just a large number that is easy to remember.
Keep ROW(A1) and -1 and 0 as is.
Enter with Ctrl+Shift+Enter to get the curly brackets. Do not type them.
Always cross check to make sure the formula worked. Use evaluate formula in the formula auditing menu to see how it works.
Let me know if you get it to work or not.