Count 350 SS numbers, exclude duplicates

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

Hi Marsha,

One way

=SUMPRODUCT((A1:A200<>"")/COUNTIF(A1:A200,A1:A200&""))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Marsha" <Marsha@discussions.microsoft.com> wrote in message
news:E362D9A0-8A06-43E4-81DD-0B2F28C6C18E@microsoft.com...
> 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

Run an autofilter, selecting "unique records". After, you merely need to
count the entries using the COUNT function.

wazooli

"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

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