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]
