Check latest purchase prices from supplier

ehietland

New Member
Joined
Jul 10, 2018
Messages
6
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. :biggrin:

Have a nice day.


articlepriceinvoice nr supplier
abc0021ND$62,00201840183
abc0021ND$67,31201740833
abc0021ND$68,33201740741
abc0060ND$46,00201740718
abc0060ND$45,03201740580
abc0060ND$41,30201740536
abc02121-8074$68,00201740859
abc02121-8074$60,49201740658
abc02121-8074$60,492016400801
abc02121-9021$52,00201740741
abc02121-9021$51,14201740501
abc02121-9021$51,14201740328

<tbody>
</tbody>

<tbody>
</tbody>


Best regards, Erwin
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top