Check latest purchase prices from supplier

[ehietland]

Dear people,

We have received an Excel sheet of our supplier with our purchase prices from the beginning of 2017 with the invoice numbers. I want to check our latest purchase prices with the purchase prices in our ERP system.

I do not know how to make one list with article numbers on the left and on the right side the latest (highest invoice number) the purchase price.

Who can help me with this? Can I add an Excel doc? Sorry I am new here.

Thanks in advance.

Have a nice day.


[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 513"]
<tbody>[TR]
[TD]article[/TD]
[TD]price[/TD]
[TD]invoice nr supplier[/TD]
[/TR]
[TR]
[TD]abc0021ND[/TD]
[TD]$62,00[/TD]
[TD]201840183[/TD]
[/TR]
[TR]
[TD]abc0021ND[/TD]
[TD]$67,31[/TD]
[TD]201740833[/TD]
[/TR]
[TR]
[TD]abc0021ND[/TD]
[TD]$68,33[/TD]
[TD]201740741[/TD]
[/TR]
[TR]
[TD]abc0060ND[/TD]
[TD]$46,00[/TD]
[TD]201740718[/TD]
[/TR]
[TR]
[TD]abc0060ND[/TD]
[TD]$45,03[/TD]
[TD]201740580[/TD]
[/TR]
[TR]
[TD]abc0060ND[/TD]
[TD]$41,30[/TD]
[TD]201740536[/TD]
[/TR]
[TR]
[TD]abc02121-8074[/TD]
[TD]$68,00[/TD]
[TD]201740859[/TD]
[/TR]
[TR]
[TD]abc02121-8074[/TD]
[TD]$60,49[/TD]
[TD]201740658[/TD]
[/TR]
[TR]
[TD]abc02121-8074[/TD]
[TD]$60,49[/TD]
[TD]2016400801[/TD]
[/TR]
[TR]
[TD]abc02121-9021[/TD]
[TD]$52,00[/TD]
[TD]201740741[/TD]
[/TR]
[TR]
[TD]abc02121-9021[/TD]
[TD]$51,14[/TD]
[TD]201740501[/TD]
[/TR]
[TR]
[TD]abc02121-9021[/TD]
[TD]$51,14[/TD]
[TD]201740328[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


Best regards, Erwin

 

[footoo]

Make a copy of the data first
Select columns A:C
Sort the data by Article (ascending) / Invoice (descending.
Go to Data/Data Tools/Remove Duplicates and select Article/OK

 

[ehietland]

Dear footoo,

Thanks a lot. Works very well. Have a nice weekend.