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
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

footoo

Well-known Member
Joined
Sep 21, 2016
Messages
3,055
Office Version
  1. 2016
Platform
  1. Windows
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:

Watch MrExcel Video

Forum statistics

Threads
1,114,554
Messages
5,548,713
Members
410,866
Latest member
StuartAllison
Top