I have sales file where each row contains information about an individual
part that is being produced and sold. When I ran a pivot table report for
sales by program there were two identical entries for "Program X". I've
looked at the entry detail and both have the same text entered (including use
of caps) and "general" formatting. Any other ideas? This seemingly small
error is causing issues with later calculations.

Thanks