I ibeetb Jul 25, 2003 #1 I need to count the unique (non-duplicate) values in a column range. Does anybody know an Excel or VBA function to do this?
I need to count the unique (non-duplicate) values in a column range. Does anybody know an Excel or VBA function to do this?
K Ken Wright Jul 25, 2003 #2 =SUM(1/COUNTIF(A1:A1000,A1:A1000)) (Array Entered - CTRL+SHIFT+ENTER) or =SUM(N(FREQUENCY(A1:A1000,A1:A1000)>0)) (Array Entered - CTRL+SHIFT+ENTER) (Numbers only in a mix of numbers & Text)
=SUM(1/COUNTIF(A1:A1000,A1:A1000)) (Array Entered - CTRL+SHIFT+ENTER) or =SUM(N(FREQUENCY(A1:A1000,A1:A1000)>0)) (Array Entered - CTRL+SHIFT+ENTER) (Numbers only in a mix of numbers & Text)
R Ron de Bruin Jul 25, 2003 #3 See this page http://www.cpearson.com/excel/duplicat.htm#CountingUnique
