Re: count occurances of string

[Shane Devenshire <ShaneDevenshire@CS.COM>]

Hi Andy,

> Quit true I would have given you the *x* approach if I had thought you
> wanted to find the characters anywhere in the entry.  FYI: you can also use "?"
> as a single character wildcard for the COUNTIF and SUMIF functions, for
> example, ??B* would find all the items that contain a B in the third position of
> course you need to get it into the correct format for the COUNTIF criteria:
> "??"&A1&"*".

Sincerely,
Shane Devenshire
Excel MVP

>
> Nice use of the wildcard Shane, and in a "ordinary" formula as well=20
> Just one point - I believe that your formula works only if the string =
> you are searching for is in the first  (or left most characters) of the =
> range being searched - so I modified it to=20
>
> =3DCOUNTIF(A200:BZ200,"*"&A1&"*")
>
> - but all credit must go to you, and I didn't make it totally clear =
> that there may be other charates in front of the chicks or photo example =
> I gave you
>

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G