# Check latest purchase prices from supplier

#### ehietland

##### New Member
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.

Have a nice day.

 article price invoice nr supplier abc0021ND \$62,00 201840183 abc0021ND \$67,31 201740833 abc0021ND \$68,33 201740741 abc0060ND \$46,00 201740718 abc0060ND \$45,03 201740580 abc0060ND \$41,30 201740536 abc02121-8074 \$68,00 201740859 abc02121-8074 \$60,49 201740658 abc02121-8074 \$60,49 2016400801 abc02121-9021 \$52,00 201740741 abc02121-9021 \$51,14 201740501 abc02121-9021 \$51,14 201740328

<tbody>
</tbody>

<tbody>
</tbody>

Best regards, Erwin

### 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
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:

#### ehietland

##### New Member
Dear footoo,

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