Unexplainable Duplicate Entries
 

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

Matthew -

Make sure the text is IDENTICAL - meaning no leading or trailing spaces on
one that do not appear on the other. To Excel, "Program X " is a different
value than "Program X"

"matthews_jd" wrote:

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