Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a large worksheet with a column containing a list of names. Some names
appear several times. I need to get a count of names. |
#2
![]() |
|||
|
|||
![]()
Steembeem, try something like this,
=COUNT(IF(FREQUENCY(A:A,A:A),1)) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Steembeem" wrote in message ... I have a large worksheet with a column containing a list of names. Some names appear several times. I need to get a count of names. |
#3
![]() |
|||
|
|||
![]()
Try this:
=SUMPRODUCT((A1:A30<"")/COUNTIF(A1:A30,A1:A30&"")) Just don't use an entire column as a range (A:A). -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Steembeem" wrote in message ... I have a large worksheet with a column containing a list of names. Some names appear several times. I need to get a count of names. |
#4
![]() |
|||
|
|||
![]()
Check this out also:
http://support.microsoft.com/kb/q268001/ Steembeem wrote: I have a large worksheet with a column containing a list of names. Some names appear several times. I need to get a count of names. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count number of Unique values | Excel Worksheet Functions | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
How do I count or display unique data in a column? | Excel Worksheet Functions | |||
Count of unique items meeting condition | Excel Worksheet Functions |