Pivot Table Filter List

[PHnew]

One of my pivot table filters has multiple options of the same field. How can I get it to clear?

My data list is:
Mar 17
Mar 18 afternoon
Mar 18 night
Mar 20 afternoon
Apr 2

My filter list is showing up like:
Mar 20 afternoon
Mar 17
Apr 2
Mar 18 afternoon
Mar 18 night
Mar 20 afternoon
Apr 2

I've tried editing my name and redefining the range, but on the pivot table two of the items appear twice?

 

[Fazza]

Names appearing twice, IMO, means only that they are different. Such as, one has a trailing space. That is, one might be "like this" and the other "like this ". Suggest you carefully check the source data to identify the difference in your particular case.

To clear old names, there is some well presented info at http://www.contextures.com/xlPivot04.html

HTH

 

[PHnew]

Yes, I drug it off, refreshed and moved it back. My list updated. Thanks!