A B C
D
1 Purchase Date Description Dimensions Unit Price
2 1/1/05 SCE41B .125" x 42" x 50' $100.00
3 2/1/05 SCE41B .125" x 42" x 50' $100.00
4 3/1/05 SCE41B .125" x 42" x 50' $100.00
5 4/1/05 SCE41B .125" x 42" x 50' $100.00
6 5/1/05 SCE41B .125" x 42" x 50' $100.00
7 6/1/05 SCE41B .125" x 42" x 50' $100.00
I only put the first few colums of an item as an example. Basically I want
to keep the row that has the most recent purchase date and delete the
previous dates without having to go through and manually deleting them like i
am doing now.
"Bernie Deitrick" wrote:
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.