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.
|