View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GBONDI GBONDI is offline
external usenet poster
 
Posts: 1
Default Excel Pivot Table - Counting Unique Values within one column of da

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