Thread: Excel formula to count the number of records which contains a certaintext (wildcard)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote