Delete duplicate (with ref to another cell included).

[mr_spaceuk]

Hi all,

I have a requirement to delete duplicate rows but also ref them against another cell. For example:

246749 - 325.39
246749 - 325.06
246758 - 634.19
246758 - 634.15
246757 - 240.75
246757 - 240.19

Delete the red ones as they are a duplicate and have the lower number in second colum.
(There may be more than 2 of each duplicate in the application).

[martindwilson]

perhaps array entered with ctrl shift enter
=AND(COUNTIF($A$1:$A$20,A1)>1,MIN(IF($A$1:$A$20=A1,$B$1:$B$20,""))=B1)
dragged down then filter on true and delete
see link below how to enter array formula
edit hold that probably
=MAX(($A$1:$A$20=A1)*($B$1:$B$20))=B1 again array entered then filter on false and delete would be better as that only find top value and if there are more than 2 lower it will find them but i havent thought what happens if 2 max are the same yet doh!