Duplicate Entries

[Chance]

I down load a PO log from our accounting program (AS400)
into excel. From there I have set up different pivot
tables and charts for different things. Is there a way
that when I copy the po log the next day and paste it on
the summary page that it would show all the duplicate
entries. Maybe highlight them or something along those
lines. That way I can delete them. Some entries might have
duplicate po numbers beacuse there is 2 sperate tickets
with that number. That is why I need to choose the ones to
delete.

Thanks,
Chance

 

[pfsardella]

Chip Pearson has formulas for highlighting duplicate entries.

http://www.cpearson.com/excel/duplicat.htm

HTH
Paul