Unexplainable Duplicate Entries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Query 3
Summing Duplicate Entries 1
Pivt or grouping or some other means to summarize data 2
Daily log 5
How to get pivot table to list duplicate entries in column fields? 2
Pivot Table custom calculations 1
Pivot Table custom calculations 2
Count Distinct Values 7

Back
Top