Count 350 SS numbers, exclude duplicates

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

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

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
>
>
>