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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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