So simple to everyone else

  • Thread starter Thread starter SO CONFUSED
  • Start date Start date
S

SO CONFUSED

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.
 
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
 
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
 
Back
Top