counting alpha data
 

I am trying to count how many times a name appears in a list. Is there a
formula?

counting alpha data
 

Hi,

use: COUNTIF(List,Name)

=COUNTIF(A1:A1000,"Shane") counts the number of times shane appears in the
range.

--
Cheers,
Shane Devenshire


"myrtlethorn" wrote:

I am trying to count how many times a name appears in a list. Is there a
formula?

counting alpha data
 

And if Shane Devenshire is in the list, and you want it counted also, try:

=COUNTIF(A1:A1000,"Shane*")

And for Devenshire, Shane, try:

=COUNTIF(A1:A1000,"*Shane")
Or
=COUNTIF(A1:A1000,"*Shane*")
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ShaneDevenshire" wrote in
message ...
Hi,

use: COUNTIF(List,Name)

counts the number of times shane appears in the
range.

--
Cheers,
Shane Devenshire


"myrtlethorn" wrote:

I am trying to count how many times a name appears in a list. Is there a
formula?