D Douglas Aug 6, 2003 #1 Dear Folks, Using Excel 97--- I wish to count unique values in a list of values.....any ideas?
J Jason Morin Aug 6, 2003 #2 There are a few methods. Here's one (assuming no blanks in the data): =SUM(1/COUNTIF(rng,rng)) Enter it with ctrl-shift-enter. HTH Jason Atlanta, GA
There are a few methods. Here's one (assuming no blanks in the data): =SUM(1/COUNTIF(rng,rng)) Enter it with ctrl-shift-enter. HTH Jason Atlanta, GA
D Douglas Aug 6, 2003 #3 Thanks... Saw a suggestion in the Knowledge base to use FREQUENCY, as well =SUM(IF(FREQUENCY($B$2:$B$58,$B$2:$B$58)>0,1))
Thanks... Saw a suggestion in the Knowledge base to use FREQUENCY, as well =SUM(IF(FREQUENCY($B$2:$B$58,$B$2:$B$58)>0,1))
