Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table Unique Count
Is there a way for me to get a unique count of data text? I have the
following table format - Count of User Group User CS DES ECS EDM Grand Total Abb, Michael 2 2 2 Abl, Denise 3 3 How do I get a unique count of user by group, in other words, my first example should be 1 under EDM for Michael. Thanks |
#2
|
|||
|
|||
A pivot table won't calculate a unique count. You could add a column to
the list, then add that field to the pivot table. For example, to count unique users per group, where user is in column A, and group is in column B: =IF(SUMPRODUCT(($A$2:$A2=A2)*($S$2:$S2=S2))1,0,1) Copy this formula down to all rows in the list. bsantona wrote: Is there a way for me to get a unique count of data text? I have the following table format - Count of User Group User CS DES ECS EDM Grand Total Abb, Michael 2 2 2 Abl, Denise 3 3 How do I get a unique count of user by group, in other words, my first example should be 1 under EDM for Michael. Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Count Distinct Values by Group Using Pivot Table (NM) | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
How do I get a pivot table to sum instead of giving me a count? | Excel Worksheet Functions |