Botom post
On Saturday 25 June 2005 04:29 am, Fred Grant wrote:
> I can't get the "ANDERSON.*" example you cite to work either. It
> shows zero count even though I have several but with different first
> names. Does this work for you?
>
> On Fri, 2005-06-24 at 22:31, Anthony Chilco wrote:
> > Hi Fred,
> > It appears that the regular expression search in countif only
> > supports literal strings and not references to cells containing a
> > string. In your case =COUNTIF(A1:A27;D12), where D12 contains
> > "ANDERSON.*" won't work, while =COUNTIF(A1:A27;"ANDERSON.*") will.
> > You could parse the column into first and last names.
> > tc
> >
> > Fred Grant wrote:
> > >I have a list of names with "LASTNAME,FIRSTNAME" format all in one
> > >column. I would like to be able to count the number of last names
> > > that are alike, eg ANDERSON but may have a different FIRSTNAME.
> > > I can't get any wild cards to work. The help file suggests that
> > > "ANDERSON.*" should do the trick but it doesn't work for me.
> > >
> > >Any ideas?
I just populated column A with 5 rows similar to your
"LASTNAME,FIRSTNAME" format. Three had one LASTNAME, and two had
another LASTNAME. The COUNTIF(A1:A5;"LASTNAME.*") format correctly
counted both LASTNAME's. I was using the Linux version. What we need to
see is a copy of your actual function. (Highlight the COUNTIF function
in the Input line box, copy it, and paste that into your email.) There
might be a typographical problem.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
