the data is alike
A
B
C
A
when I count, I want to count how many distinct items, the result of above
data shouls show only 3 (A, B and C).
when I use pivot, the total shows 4 (counting 2 As).
Pls help how to get this done.
the data is alike
A
B
C
A
when I count, I want to count how many distinct items, the result of above
data shouls show only 3 (A, B and C).
when I use pivot, the total shows 4 (counting 2 As).
Pls help how to get this done.
A pivot table won't calculate a unique count. You could add a column to
the list, then add that field to the pivot table.
For example, to count unique items in column A, use the following formula:
=IF(COUNTIF($A$1:A2,A2)=1,1,0)
Copy this formula down to all rows in the list, then add the field to
the pivot table.
soe wrote:
> the data is alike
> A
> B
> C
> A
> when I count, I want to count how many distinct items, the result of above
> data shouls show only 3 (A, B and C).
> when I use pivot, the total shows 4 (counting 2 As).
> Pls help how to get this done.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks