View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default 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?