Hi Guys

I am in the process of building a new ecommerce website. I have a number of suppliers that produce inventory feeds in CSV format that has the following information:

> Part Number
> Description
> Quantity
> Price
> Supplier Name

Many of the suppliers stock the same items which can be identified by part number. I would like to be able to combine my supplier 'feeds' into one large spreadsheet and then apply a rule that will identify duaplicates based on part number and delete all except the cheapest row. Does anyone know if this is possible and how I can do it?

Kind regards