So simple to everyone else
 

I need an answer for an easy question.

In this example I have the following names

COLUM A COLUM B
FRED FLINTSTONE
BARNEY RUBBLE
DINO FLINTSTONE
WILMA FLINTSTONE
HUMPHREY BEAR

AND SO THE LIST GOES ON AND ON FOR ABOUT 200 NAMES I HAVE.

i WANT TO GET A FORMULA THAT WILL TELL ME HOW MANY PEOPLE ARE IN THIS LIST
ALL TOGETHER IN COLUM A ONLY. CAUSE IF I USE A AND B THE SAME PERSON GETS
COUNTED TWICE.

So simple to everyone else
 

http://www.cpearson.com/Excel/Duplicates.aspx


U¿ytkownik "SO CONFUSED" <SO napisa³ w
wiadomo¶ci ...
I need an answer for an easy question.

In this example I have the following names

COLUM A COLUM B
FRED FLINTSTONE
BARNEY RUBBLE
DINO FLINTSTONE
WILMA FLINTSTONE
HUMPHREY BEAR

AND SO THE LIST GOES ON AND ON FOR ABOUT 200 NAMES I HAVE.

i WANT TO GET A FORMULA THAT WILL TELL ME HOW MANY PEOPLE ARE IN THIS LIST
ALL TOGETHER IN COLUM A ONLY. CAUSE IF I USE A AND B THE SAME PERSON GETS
COUNTED TWICE.

So simple to everyone else
 

hi
all the names in the sample list are unique. is that true of the entire list?
if so you could use the counta formula
=COUNTA(A2:A6) or a range that covers your entire list.

Regards
FSt1

"SO CONFUSED" wrote:

I need an answer for an easy question.

In this example I have the following names

COLUM A COLUM B
FRED FLINTSTONE
BARNEY RUBBLE
DINO FLINTSTONE
WILMA FLINTSTONE
HUMPHREY BEAR

AND SO THE LIST GOES ON AND ON FOR ABOUT 200 NAMES I HAVE.

i WANT TO GET A FORMULA THAT WILL TELL ME HOW MANY PEOPLE ARE IN THIS LIST
ALL TOGETHER IN COLUM A ONLY. CAUSE IF I USE A AND B THE SAME PERSON GETS
COUNTED TWICE.

So simple to everyone else
 

Try this array formula:
=SUM(1/COUNTIF(A1:A5,A1:A5))

Adjust your range to fit. Array formulas are committed with
Ctrl-Shift-Enter. Excel will put braces around the formula to confirm its
acceptance.

Regards
Fred

"SO CONFUSED" <SO wrote in message
...
I need an answer for an easy question.

In this example I have the following names

COLUM A COLUM B
FRED FLINTSTONE
BARNEY RUBBLE
DINO FLINTSTONE
WILMA FLINTSTONE
HUMPHREY BEAR

AND SO THE LIST GOES ON AND ON FOR ABOUT 200 NAMES I HAVE.

i WANT TO GET A FORMULA THAT WILL TELL ME HOW MANY PEOPLE ARE IN THIS LIST
ALL TOGETHER IN COLUM A ONLY. CAUSE IF I USE A AND B THE SAME PERSON GETS
COUNTED TWICE.

So simple to everyone else
 

Hello,

I suggest to array-enter into an area of 200 rows and 3 columns:
=Pfreq(A2:A999,B2:B999)

Pfreq you can find he
http://www.sulprobil.com/html/pfreq.html

Regards,
Bernd