| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PivotTable count unique
I have several pivot tables linked to a single database with 12 fields
All database records are unique One pivot table looks at just 2 fields from 12 as per the simplified example below: Field1 Field2 A abc A abc A def B ghi C hij Would like the pivot table to count the unique occurences from Field2 against Field1 The result would be: A 2 B 1 C 1 Any idea how this could be achieved within a pivot table? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique dates within each unique ID | Excel Worksheet Functions | |||
| PivotTable Row Count | Excel Discussion (Misc queries) | |||
| Attempting to sort unique/only count first record in each unique g | Excel Discussion (Misc queries) | |||
| Pivottable to count non-zeros | Excel Discussion (Misc queries) | |||
| How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
Threaded Mode
