Thank you. It worked!

"Bob Phillips" wrote:

> No just enter it in any cell, and it will count the number of SS entries.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Marsha" <Marsha@discussions.microsoft.com> wrote in message
> news:72088002-023E-472E-BFB4-391F6F634655@microsoft.com...
> > At the risk of sounding studpid , do I enter this formual into the
> > destination cell, and then highlight my range and hit enter? I really
> don't
> > do much with Exel except enter informtation. Thanks again.
> > Marsha
> >
> > =SUMPRODUCT((A1:A200<>"")/COUNTIF(A1:A200,A1:A200&""))
> >
> >
> > "Marsha" wrote:
> >
> > > I need to be able to count information based on approximately 350 social
> > > security numbers, exlcuding duplicates. Any ideas on the formula?
> Thanks so
> > > much,
> > > Marsha
>
>
>