Counting unique entries in a list
Posted by Jon Ballou on February 20, 2001 11:14 PM
Anyone have a simple formula for counting the number of unique entries in a column?
Thanks much
Posted by Aladin Akyurek on February 21, 2001 12:28 AM
If your column contains just numeric values, you can use
=SUM(IF(FREQUENCY(A1:A9,A1:A9)>0,1))
Aladin
Posted by Jon on February 21, 2001 12:40 AM
What if the list contains text?
Jon
Posted by David Hawley on February 21, 2001 1:04 AM
Hi Jon
Assuming your list is in column A, Put: =SUBTOTAL(3,A:A)
Make sure your data has a heading, then select any cell in your list and go to Data>Filter>Advanced Filter, Select "Unique records only" and click OK.
Dave
OzGrid Business Applications
Posted by Aladin Akyurek on February 21, 2001 1:44 AM
=SUM(IF(FREQUENCY(MATCH(A1:A6,A1:A6,0),MATCH(A1:A6,A1:A6,0))>0,1))
Aladin
