In sheet2, assuming you have "String1" in column A1, enter in A2:
=SUMPRODUCT(--ISNUM(FIND(A2;Sheet1!$A$1:$A$5)))


HTH
--
AP

a écrit dans le message de
oups.com...
Sheet1
Column A
"This is my string1"
This is my string2
This is my string1 again
This is my string3
Hey This is my string1 string1
...
...

Sheet2
ColumnA
ColumnB
No of times the text string1 appeared in sheet1 3
No of times the text string2 appeared in sheet1 1
No of times the text string3 appeared in sheet1 1

Can you help me create columnB in sheet2? If a particular string, say,
string 1, appears multiple times in the same row, the count increments
only by 1, not by the number of occurences in a particular row.