Re: count occurances of string

[Andy Armstrong <a.armstrong@SHOTOVERJET.CO.NZ>]

Thanks For that Shane - I will add the ? and * tips to my ever growing
knowledge pool - one good tip deservers another - here's mine
 - The plastic things on the end of shoelaces are called aglets.

Have a good w/e everyone I'm out of here now - there are other advantages to
living in New Zealand - but being first to go home for the w/e seems a good
enough reason for now.

Regards Andy

-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-G@PEACH.EASE.LSOFT.COM]On
Behalf Of Shane Devenshire
Sent: Friday, July 25, 2003 4:40 PM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: Re: count occurances of string

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

--------------------------------------------------------------------------
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