Count 350 SS numbers, exclude duplicates

[Guest]

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

 

[Bob Phillips]

Hi Marsha,

One way

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

--

HTH

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

 

[Guest]

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

wazooli

 

[Guest]

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&""))

 

[Bob Phillips]

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)

 

[Guest]

Thank you. It worked!

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)