| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table
Hi !
I have a column of names which I need to include in a pivot table but I need the pivot table to show me only the unique count of names. NAme Month a may a may a may b may b may b may c may c may a jun a jun a jun b jun b jun b jun So I need the pivot table to show MAy JUN 3 2 so this basically shows there are 3 names in may and 2 in june. Please help! Thanks in advance ! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pivot table
Hi Nitya,
Am Tue, 16 Jun 2015 02:59:00 -0700 (PDT) schrieb Nitya Satheesh: NAme Month a may a may a may b may b may b may c may c may a jun a jun a jun b jun b jun b jun copy your data to another range = Data = Remove Duplicates and create the Pivot table with the new data range. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
pivot table
Thanks Claus!! That helped !
On Tuesday, June 16, 2015 at 3:49:26 PM UTC+5:30, Claus Busch wrote: Hi Nitya, Am Tue, 16 Jun 2015 02:59:00 -0700 (PDT) schrieb Nitya Satheesh: NAme Month a may a may a may b may b may b may c may c may a jun a jun a jun b jun b jun b jun copy your data to another range = Data = Remove Duplicates and create the Pivot table with the new data range. Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Child pivot table's source breaking from parent pivot table | Excel Programming | |||
| Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
| Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Linear Mode
