Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count number of unique items in a column that contains duplicates
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 | |
|
|
Similar Threads | ||||
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 |