Count 350 SS numbers, exclude duplicates

M

Marsha

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
 
B

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

Wazooli

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

wazooli
 
M

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

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

Marsha

Thank you. It worked!

Bob Phillips said:
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)
Click to expand...
 
Top