| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table: how to count unique? need help!
this a table similar to the one I really have
serialnb label 111 a 111 b 222 a I want to create a pivot that shows how many *unique* serials exist, and also per label, etc. Doing the "usual" pivot I get the following Count of serialnb serialnb label Total 111 a 1 b 1 222 a 1 Grand Total 3 How can I show the results I want? (should be 2 for unique serial numbers) Many thanks! luis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
| How do I use a pivot table to get an average count? | Excel Discussion (Misc queries) | |||
| pivot table | Excel Discussion (Misc queries) | |||
| pivot table created from another pivot table | Excel Worksheet Functions | |||
| Count Unique in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
