Ken,

Post a very small sample of your data, and indicate what you would consider a duplicate that needs
to be deleted, and what needs to be saved. It should be easy to do, using a helper column of
formulas or filters.

HTH,
Bernie
MS Excel MVP


"Ken McGonagle" <Ken wrote in message
...
I am working on spreadsheets that contain 9 colums and anywhere up to 1,500
rows of duplicate information. I am trying to update my customer bases
pricing for an upcoming price increase. One customer could only buy 10
different items but purchase those items hundreds of times within a year. I
am trying to find a macro or something that can identify duplicates and leave
the most current item on the spreadsheet. I have over 1,000 to do right now
and going through and manually deleting that info isn't cutting the mustard.
Any help would be very appreciated.