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? > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
