I have a excel spreadsheet kind of structured like this.
What I want to do is filter all the results, removing the rows where the product link is duplicated but keep the row with the lowest price. Is this possible? I looked through various filters in Excel 2007 but it wouldn't work.
Code:
Product Price Product link
--------- ---------
£12.99 product1.html
£13.99 product2.html
£17.99 product1.html
£24.99 product3.html
£34.99 product3.htmlWhat I want to do is filter all the results, removing the rows where the product link is duplicated but keep the row with the lowest price. Is this possible? I looked through various filters in Excel 2007 but it wouldn't work.