Maybe you don't need the pivottable.

Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx

PMST wrote:

I'm running a Pivot Table to show all duplicate entries in my spreadsheet.
Is there a way for me to automatically remove those dupicate entries without
manually going back in and removing them one at a time?

--

Dave Peterson