From your latest response to Dave in the other branch,

wrote
Dave I got this to work but the problem with it is that it returns all
the rows that include the keyword but it also includes everything else
in that row, so I still end up searching the spreadsheet for the
keyword with my eyes. Is there anything I can add that will eliminate
the rest of the cells that do not include the keyword?

it seems like you're after a sort-of "columnwise" filter

Here's a slightly revised version to the earlier construct posted
which could achieve your intents ..

http://www.savefile.com/files/4205600
Count task occurence n List dates_tasks.xls

Revision made:

In sheet: Y,

In B2, copied across to say, K2*, then filled down:
=IF(ISERROR(SMALL(X!$AH2:$BL2,COLUMN(A1))),"",TEXT (INDEX(X!$B$1:$AF$1,MATCH(
SMALL(X!$AH2:$BL2,COLUMN(A1)),X!$AH2:$BL2,0)),"dd-mmm-yyyy")&CHAR(10)&INDEX(
X!$B2:$AF2,MATCH(SMALL(X!$AH2:$BL2,COLUMN(A1)),X!$ AH2:$BL2,0)))

Format B2 to wrap text
(via: Format Cells Alignment tab Check Wrap Text OK)

*assuming a max of 10 dates per item input in A1

Now, the corresponding dates & text for the occurences
will be listed next to the counts in A2:A10
(instead of just the dates)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---