| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables Drop Down Data Appearing Twice
I am having trouble with certain criteria in the headings drop down list
appearing twice. I have checked the Pivot Tables' data range, and all spelling and punctuation is uniform, therefore each criteria should only appear once. This is only happening to 3 out of 24 entries, and each duplicate entry in the drop down is reulting in different data. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Tables Drop Down Data Appearing Twice
Maybe you have spaces after the entries, like "Mwango" and "Mwango "
This would cause multiple entries to appear, although they would look like the same spelling, punctuation, etc. Mark Mwango wrote: I am having trouble with certain criteria in the headings drop down list appearing twice. I have checked the Pivot Tables' data range, and all spelling and punctuation is uniform, therefore each criteria should only appear once. This is only happening to 3 out of 24 entries, and each duplicate entry in the drop down is reulting in different data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot data appearing wrong. | Excel Discussion (Misc queries) | |||
| Pivot tables and drop-down lists | New Users to Excel | |||
| pivot tables-drop data in, how to make it show as columns instead | Excel Discussion (Misc queries) | |||
| Drop-down data not appearing in exported XML | Excel Discussion (Misc queries) | |||
| Pivot Tables - updating drop down lists | Excel Programming | |||
Linear Mode
