Excel Pivot Table - Counting Unique Values within one column of da

G

GBONDI

The excel worksheet that I am using includes three columns. Column A, and
Column B contain numeric values that I wish to sum (no problem). However
column C includes an text string composed of alpha and numeric characters
some of which include the same ("Duplicate") Value. I wish to count the
number of Unique values in Column C.

For Example Column A includes Debits, Column B includes credits and Column C
includes account numbers. The information is at a transaction level with
multiple entries for the same account number. I wish to count the number of
Unique Account numbers. Is there a way that this can be done in an excel
pivot table?
Thank you
 
R

Roger Govier

Hi

You can't do it within the PT itself.
Add another column (D) to your source table with the following formula in D2
=IF(COUNTIF($C$2:C2,C2)=1,1,"")
and copy down.
In D1 give a header Unique_Code

Expand your PT source to include column D and add Sum of Unique_Code to the
data area
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top