M Matt Mar 31, 2004 #1 Hello, can somebody help me? I want to count different values inserted between A1 and A23 Thanks
F Frank Kabel Mar 31, 2004 #2 Hi have a look at http://www.cpearson.com/excel/duplicat.htm#CountingUnique to count unique values or you may use the formula =SUMPRODUCT((A1:A23<>"")/COUNTIF(A1:A23,A1:A23&""))
Hi have a look at http://www.cpearson.com/excel/duplicat.htm#CountingUnique to count unique values or you may use the formula =SUMPRODUCT((A1:A23<>"")/COUNTIF(A1:A23,A1:A23&""))