A Andrew@rushington Nov 30, 2007 #1 can i use countif to count the how many different values exist in a column.
R RichardSchollar Nov 30, 2007 #2 can i use countif to count the how many different values exist in a column. Click to expand... Assume Col A you want to count a list of uniques (excluding blanks) within A1:A1000: =SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&"")) Richard
can i use countif to count the how many different values exist in a column. Click to expand... Assume Col A you want to count a list of uniques (excluding blanks) within A1:A1000: =SUMPRODUCT((A1:A1000<>"")/COUNTIF(A1:A1000,A1:A1000&"")) Richard
