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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 06:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com