Excel formula to count the number of records which contains a certaintext (wildcard)
 

Hello,

If you want to count the number of records which contains a certain
text you can use in excel the formula
=COUNTIF(C:C;"aaa")

Which formula can I use if I want to count the number of records which
contains 'aaa' within the cells.
For example

C1= aaa
C2= bbb
C3= aaaccc
C4 = kkkaaabbb

The number of records which contain the text 'aaa' in this example is
3.
If you see I want to use something like a wildcard in a formula.

regards,
Johan.

Excel formula to count the number of records which contains a certain text (wildcard)
 

Hi Johan,

Am Thu, 16 Feb 2012 03:27:27 -0800 (PST) schrieb johan:

C1= aaa
C2= bbb
C3= aaaccc
C4 = kkkaaabbb

try:
=COUNTIF(C:C,"*aaa*")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Excel formula to count the number of records which contains acertain text (wildcard)
 

On Feb 16, 5:40*am, Claus Busch wrote:
Hi Johan,

Am Thu, 16 Feb 2012 03:27:27 -0800 (PST) schrieb johan:

C1= * *aaa
C2= * *bbb
C3= * *aaaccc
C4 = * kkkaaabbb

try:
=COUNTIF(C:C,"*aaa*")

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

This would NOT provide the desired answer. You need a looping macro
using vba FINDNEXT to find each occurence and add 1 to the count if
found.

Excel formula to count the number of records which contains acertain text (wildcard)
 

Thanks,

=COUNTIF(C:C;"*aaa*")
Very simple and..... it works.

regards,
Johan.