Eliminate Duplicates based on several criteria

**nomis65** · 09-29-2014, 02:56 PM

Hi,

I have an Excel Sheet with all the purchases from my customers (13 000 rows) including 5 collumns:
1- Customer name
2- Date of puschase
3- Item Code
4- Item description
5- Unit Price

For some reason, some customer paid different prices for the same item. I want to keep the last price paid for each items purchased by each customer. I guess only a macro would work?

Thanks for helping!

Simon

Duplicates.xlsx

**natefarm** · 09-29-2014, 05:07 PM

Please Login or Register  to view this content.

**nomis65** · 09-29-2014, 05:18 PM

Fantastic, Thanks so much!

**nomis65** · 09-29-2014, 05:50 PM

I just notice that the macro keep the oldest price when in fact, I need the most recent based on the purshasing Date (collumn B)...

**nomis65** · 09-30-2014, 06:38 AM

I tried to modify the command to Descending for collumn B (Date) but it didn't worked...

Thanks for helping,

Simon

**natefarm** · 09-30-2014, 09:42 AM

In your attachment, I highlighted the ones I expected it to keep and then ran the code. It seems to work fine, so maybe I'm misunderstanding what you want.

After.JPG

Sorry, the attachment uploader seems to be on the fritz. The Before pic is blank, and it's not letting me replace it. I guess you can look back at the attachment.