software

I have data like this:

ABCBOX1
ABCBOX1
EFGBOX2
HIJBOX3
KLMBOX4

And would like to use the Pivot Table to count the unique values in ColA:

BOX1 1
BOX2 1
BOX3 1
BOX4 1For some reason, I am getting the following:

BOX1 2
BOX2 1
BOX3 1
BOX4 1

Thank you in advance.Pivot table Count just counts the records. Not just the unique values. There
are 2 records that have BOX1 in column B. Both of them have values ABC in
column A. No matter what the column A values were, however, the pivot table
would still count 2 BOX1's.

quot;carlquot; wrote:

gt; I have data like this:
gt;
gt; ABCBOX1
gt; ABCBOX1
gt; EFGBOX2
gt; HIJBOX3
gt; KLMBOX4
gt;
gt; And would like to use the Pivot Table to count the unique values in ColA:
gt;
gt; BOX1 1
gt; BOX2 1
gt; BOX3 1
gt; BOX4 1
gt;
gt;
gt; For some reason, I am getting the following:
gt;
gt; BOX1 2
gt; BOX2 1
gt; BOX3 1
gt; BOX4 1
gt;
gt; Thank you in advance.
gt;

A pivot table won't count unique values, but there's a workaround here,
if you're using an Excel list as the source:

www.contextures.com/xlPivot07.html#Unique

carl wrote:
gt; I have data like this:
gt;
gt; ABCBOX1
gt; ABCBOX1
gt; EFGBOX2
gt; HIJBOX3
gt; KLMBOX4
gt;
gt; And would like to use the Pivot Table to count the unique values in ColA:
gt;
gt; BOX1 1
gt; BOX2 1
gt; BOX3 1
gt; BOX4 1
gt;
gt;
gt; For some reason, I am getting the following:
gt;
gt; BOX1 2
gt; BOX2 1
gt; BOX3 1
gt; BOX4 1
gt;
gt; Thank you in advance.
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html