How can I get a count of unique records, by group instead of the # of occurances for that record.
G Gail McKee Aug 25, 2004 #1 How can I get a count of unique records, by group instead of the # of occurances for that record.
D Dave Peterson Aug 26, 2004 #2 I'm not sure I understand, but if you want to count the number of unique values in a field, you can use a helper column: Say your data is in A2:A999 (headers in A1) then use a helper column and put a formula like: =if(countif($a$2:$a2,a2)=1,1,0) Then use this column in your pivottable (as sum).
I'm not sure I understand, but if you want to count the number of unique values in a field, you can use a helper column: Say your data is in A2:A999 (headers in A1) then use a helper column and put a formula like: =if(countif($a$2:$a2,a2)=1,1,0) Then use this column in your pivottable (as sum).
G Gail McKee Aug 30, 2004 #3 -----Original Message----- I'm not sure I understand, but if you want to count the number of unique values in a field, you can use a helper column: Say your data is in A2:A999 (headers in A1) then use a helper column and put a formula like: =if(countif($a$2:$a2,a2)=1,1,0) Then use this column in your pivottable (as sum). -- Dave Peterson [email protected] . Click to expand...
-----Original Message----- I'm not sure I understand, but if you want to count the number of unique values in a field, you can use a helper column: Say your data is in A2:A999 (headers in A1) then use a helper column and put a formula like: =if(countif($a$2:$a2,a2)=1,1,0) Then use this column in your pivottable (as sum). -- Dave Peterson [email protected] . Click to expand...
