Excel filtering help

[Zaphan58]

I have a excel spreadsheet kind of structured like this.

Product Price   Product link
---------        ---------
£12.99            product1.html
£13.99            product2.html
£17.99            product1.html
£24.99            product3.html
£34.99            product3.html

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.

 

[kevpuk]

I think this would be convoluted in Excel likely VB only ?
Could the data be processed in Access ? A simple grouped query in Access would knock this out quite easliy.....

 

[Participant]

How big's the data? Quickest dirty way is just to sort the data by product link then price ascending and delete dupes.

You could highlight the product links that have been duplicated with countifs or pivot tables, but without being a dab hand at writing macros, I know of no way to achieve this automatically or with filter.