software

I need to count the occurrence of a string that would be contained in text in a column.
For example, in column J, starting at cell 1,

J
1 x1 x4
2 x1 x2 x3
3 x2 x5
4 x3 x4 x6

(For example, cell J1 equals the text string quot;x1 x4quot;.)

So, the answer to the number of times the string ''x4' occurs in J1:J4 is 2.

Is it even possible for this type of counting to be performed with an Excel formula?
How???

Thanks,

-Bill.

Bill,

Use the COUNTIF function. E.g,

=COUNTIF(J1:J4,quot;*x4*quot;)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Billquot; gt; wrote in message
...
gt;I need to count the occurrence of a string that would be
gt;contained in text in a column.
gt; For example, in column J, starting at cell 1,
gt;
gt; J
gt; 1 x1 x4
gt; 2 x1 x2 x3
gt; 3 x2 x5
gt; 4 x3 x4 x6
gt;
gt; (For example, cell J1 equals the text string quot;x1 x4quot;.)
gt;
gt; So, the answer to the number of times the string ''x4' occurs
gt; in J1:J4 is 2.
gt;
gt; Is it even possible for this type of counting to be performed
gt; with an Excel formula?
gt; How???
gt;
gt; Thanks,
gt;
gt; -Bill.
gt;
gt;
gt;
WOW, wildcards! Never knew Excel had 'em! This is gonna change LOTS of things for me...

How can I get it to work if, for example, x4 is in a table cell?
ex: if cell D3 = x4

(I can't get quot;*D3*quot; to work)

THANKS!!!!

Billquot;Chip Pearsonquot; gt; wrote in message...
gt; Bill,
gt;
gt; Use the COUNTIF function. E.g,
gt;
gt; =COUNTIF(J1:J4,quot;*x4*quot;)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Billquot; gt; wrote in message
gt; ...
gt; gt;I need to count the occurrence of a string that would be
gt; gt;contained in text in a column.
gt; gt; For example, in column J, starting at cell 1,
gt; gt;
gt; gt; J
gt; gt; 1 x1 x4
gt; gt; 2 x1 x2 x3
gt; gt; 3 x2 x5
gt; gt; 4 x3 x4 x6
gt; gt;
gt; gt; (For example, cell J1 equals the text string quot;x1 x4quot;.)
gt; gt;
gt; gt; So, the answer to the number of times the string ''x4' occurs
gt; gt; in J1:J4 is 2.
gt; gt;
gt; gt; Is it even possible for this type of counting to be performed
gt; gt; with an Excel formula?
gt; gt; How???
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; -Bill.
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
Bill,

Try

=COUNTIF(J1:J4,quot;*quot;amp;D3amp;quot;*quot;)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Billquot; gt; wrote in message
...
gt; WOW, wildcards! Never knew Excel had 'em! This is gonna change
gt; LOTS of things for me...
gt;
gt; How can I get it to work if, for example, x4 is in a table
gt; cell?
gt; ex: if cell D3 = x4
gt;
gt; (I can't get quot;*D3*quot; to work)
gt;
gt; THANKS!!!!
gt;
gt; Bill
gt;
gt;
gt; quot;Chip Pearsonquot; gt; wrote in message...
gt;gt; Bill,
gt;gt;
gt;gt; Use the COUNTIF function. E.g,
gt;gt;
gt;gt; =COUNTIF(J1:J4,quot;*x4*quot;)
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Cordially,
gt;gt; Chip Pearson
gt;gt; Microsoft MVP - Excel
gt;gt; Pearson Software Consulting, LLC
gt;gt; www.cpearson.com
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Billquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I need to count the occurrence of a string that would be
gt;gt; gt;contained in text in a column.
gt;gt; gt; For example, in column J, starting at cell 1,
gt;gt; gt;
gt;gt; gt; J
gt;gt; gt; 1 x1 x4
gt;gt; gt; 2 x1 x2 x3
gt;gt; gt; 3 x2 x5
gt;gt; gt; 4 x3 x4 x6
gt;gt; gt;
gt;gt; gt; (For example, cell J1 equals the text string quot;x1 x4quot;.)
gt;gt; gt;
gt;gt; gt; So, the answer to the number of times the string ''x4'
gt;gt; gt; occurs
gt;gt; gt; in J1:J4 is 2.
gt;gt; gt;
gt;gt; gt; Is it even possible for this type of counting to be
gt;gt; gt; performed
gt;gt; gt; with an Excel formula?
gt;gt; gt; How???
gt;gt; gt;
gt;gt; gt; Thanks,
gt;gt; gt;
gt;gt; gt; -Bill.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;
gt;
Yep, just figured that out.

Thanks, Chip, you saved my butt,

Bill.quot;Chip Pearsonquot; gt; wrote in message
.. .
gt; Bill,
gt;
gt; Try
gt;
gt; =COUNTIF(J1:J4,quot;*quot;amp;D3amp;quot;*quot;)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Billquot; gt; wrote in message
gt; ...
gt; gt; WOW, wildcards! Never knew Excel had 'em! This is gonna change
gt; gt; LOTS of things for me...
gt; gt;
gt; gt; How can I get it to work if, for example, x4 is in a table
gt; gt; cell?
gt; gt; ex: if cell D3 = x4
gt; gt;
gt; gt; (I can't get quot;*D3*quot; to work)
gt; gt;
gt; gt; THANKS!!!!
gt; gt;
gt; gt; Bill
gt; gt;
gt; gt;
gt; gt; quot;Chip Pearsonquot; gt; wrote in message...
gt; gt;gt; Bill,
gt; gt;gt;
gt; gt;gt; Use the COUNTIF function. E.g,
gt; gt;gt;
gt; gt;gt; =COUNTIF(J1:J4,quot;*x4*quot;)
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Cordially,
gt; gt;gt; Chip Pearson
gt; gt;gt; Microsoft MVP - Excel
gt; gt;gt; Pearson Software Consulting, LLC
gt; gt;gt; www.cpearson.com
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Billquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I need to count the occurrence of a string that would be
gt; gt;gt; gt;contained in text in a column.
gt; gt;gt; gt; For example, in column J, starting at cell 1,
gt; gt;gt; gt;
gt; gt;gt; gt; J
gt; gt;gt; gt; 1 x1 x4
gt; gt;gt; gt; 2 x1 x2 x3
gt; gt;gt; gt; 3 x2 x5
gt; gt;gt; gt; 4 x3 x4 x6
gt; gt;gt; gt;
gt; gt;gt; gt; (For example, cell J1 equals the text string quot;x1 x4quot;.)
gt; gt;gt; gt;
gt; gt;gt; gt; So, the answer to the number of times the string ''x4'
gt; gt;gt; gt; occurs
gt; gt;gt; gt; in J1:J4 is 2.
gt; gt;gt; gt;
gt; gt;gt; gt; Is it even possible for this type of counting to be
gt; gt;gt; gt; performed
gt; gt;gt; gt; with an Excel formula?
gt; gt;gt; gt; How???
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks,
gt; gt;gt; gt;
gt; gt;gt; gt; -Bill.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;
gt;