duplicate names in Pivot Table

[K. Georgiadis]

The more I use Excel, the more surprises I get!

I have a Pivot table based on a 16-column data list, one
of the columns being "End Uses," say, office machines,
laptops, FAX machines, etc., a total of 15 different end
uses. Each End use occurs several times in the column.
For some reason, two of these end uses, though spelled
identically, appear twice on the drop-down list of the
table. Any idea how that might have happened?

 

[Debra Dalgleish]

Probably one of the items has a space character at the end, and the
other doesn't.

 

[K. Georgiadis]

Thanks Debra. The thought occurred to me, so I copied the
first occurence of the duplicate entires and pasted them
over all the others. It didn't do the trick...Then,
remembering that one half of the data was added
subsequently (and NOT with a dynamic range -- now I do
have your OFFSET formula substituted), I thought perhaps
that Excel was treating the additional occurrences as
being different. I don't understand why it would be so,
but I ran your macro twice for removing "old items" and
the problem went away.

I don't quite understand why, but solved is solved.

My compliments on your terrific website.

 

[Debra Dalgleish]

If one of the items had a space, it would appear as a separate item in
the dropdown list. When you copied over it in the source data, that item
was removed from the table, but remained as an "old item" in the
dropdown list. The macro cleared it from them.

Thanks for letting me know that you like the website!