Thread: So simple to everyone else
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jarek Kujawa[_3_] Jarek Kujawa[_3_] is offline
external usenet poster
  
Posts: 37
Default 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.



Reply With QuoteReply With Quote