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
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