Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate data to show/print in a column
I have a pivot table that skips the duplicate data and leave the cell blank
I would like this data to show and print for sorting purposes. How can I do that |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicate data to show/print in a column
It's not possible if you still want to keep it as a pivottable.
But you could copy it and paste special|values (to another location) and fill the empty cells using techniques from Debra Dalgleish's site: http://www.contextures.com/xlDataEntry02.html But this copy won't be a pivottable anymore. PAT wrote: I have a pivot table that skips the duplicate data and leave the cell blank I would like this data to show and print for sorting purposes. How can I do that -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Duplicate Data in a Column. | New Users to Excel | |||
How do I show duplicate Data only? | Excel Discussion (Misc queries) | |||
Delete row where there is duplicate data in Column E | New Users to Excel | |||
How do i show duplicate data points on a scatter plot? | Charts and Charting in Excel | |||
Matching one column against another column of data to show the same amount of data. | Excel Worksheet Functions |