Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple lookup - or maybe not so simple - help! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel |