Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot tables and merged Cells
Howdie
Does a pivot table work with Merged Cells? Conceptually difficutl as output is in single cells but input is in multiple cells. I need to use pivot table functionality, but over merged cells. Any ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot tables and merged Cells
Another good reason to avoid merged cells. If you can't change them in the
source data, make a copy of the source with no merged cells and use this as the real source. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Darin Kramer" wrote in message ... Howdie Does a pivot table work with Merged Cells? Conceptually difficutl as output is in single cells but input is in multiple cells. I need to use pivot table functionality, but over merged cells. Any ideas? Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table and Merged Cells Help | Excel Worksheet Functions | |||
Pivot Tables - merged cell problems | Excel Discussion (Misc queries) | |||
Displaying merged cells fields in Pivot table | Excel Discussion (Misc queries) | |||
Pivot tables to refer to merged cells | Excel Discussion (Misc queries) | |||
Merged cells and Pivot table | Excel Discussion (Misc queries) |