How can I count a text value only once when there are multiple occurrences in a column?
G Guest Sep 2, 2004 #1 How can I count a text value only once when there are multiple occurrences in a column?
G Gabor Sebo Sep 2, 2004 #3 -----Original Message----- How can I count a text value only once when there are multiple occurrences in a column? . Click to expand... Hello, not too difficult. incorporate yor counting formula in this if statement: if(count according to your formula>0,1,0)
-----Original Message----- How can I count a text value only once when there are multiple occurrences in a column? . Click to expand... Hello, not too difficult. incorporate yor counting formula in this if statement: if(count according to your formula>0,1,0)