Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Pivot Table - Counting Unique Values within one column of da
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 -- Regards Roger Govier "GBONDI" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting unique values in a table | Excel Discussion (Misc queries) | |||
Counting Unique Values That Are Separate by Commas in a Column | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions |