Is there a formula to determine the number of unique items in a columm?
D Domenic Nov 4, 2004 #2 =SUM(IF(A1:A10<>"",1/COUNTIF(A1:A10,A1:A10))) ...entered using CONTROL+SHIFT+ENTER. Hope this helps
