software

Sheet1
Column A
quot;This is my string1quot;
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.In sheet2, assuming you have quot;String1quot; in column A1, enter in A2:
=SUMPRODUCT(--ISNUM(FIND(A2;Sheet1!$A$1:$A$5)))HTH
--
AP

gt; a écrit dans le message de oups.com...
gt; Sheet1
gt; Column A
gt; quot;This is my string1quot;
gt; This is my string2
gt; This is my string1 again
gt; This is my string3
gt; Hey This is my string1 string1
gt; ...
gt; ...
gt;
gt; Sheet2
gt; ColumnA
gt; ColumnB
gt; No of times the text string1 appeared in sheet1 3
gt; No of times the text string2 appeared in sheet1 1
gt; No of times the text string3 appeared in sheet1 1
gt;
gt; Can you help me create columnB in sheet2? If a particular string, say,
gt; string 1, appears multiple times in the same row, the count increments
gt; only by 1, not by the number of occurences in a particular row.
gt;
A little change.

Sheet1
Column A ColumnB
quot;This is my string1quot; Count
This is my string2 Count
This is my string1 again Don't Count
This is my string3 Count
Hey This is my string1 string1 Count

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

If columnB in sheet 1 is quot;countquot;, only then the stingx in columnA will
be counted. What should my formula be now?=SUMPRODUCT(ISNUM(FIND(A2;Sheet1!$A$1:$A$5))*(Shee t1!$B$1:$B$5=quot;Countquot;))

HTH
--
AP

gt; a écrit dans le message de oups.com...
gt; A little change.
gt;
gt; Sheet1
gt; Column A ColumnB
gt; quot;This is my string1quot; Count
gt; This is my string2 Count
gt; This is my string1 again Don't Count
gt; This is my string3 Count
gt; Hey This is my string1 string1 Count
gt;
gt; Sheet2
gt; ColumnA
gt; ColumnB
gt; No of times the text string1 appeared in sheet1 2
gt; No of times the text string2 appeared in sheet1 1
gt; No of times the text string3 appeared in sheet1 1
gt;
gt; If columnB in sheet 1 is quot;countquot;, only then the stingx in columnA will
gt; be counted. What should my formula be now?
gt;