Hi,
I have a spreadsheet (excel 2007) than contains duplicated reference numbers in one column with varying numerical values in another.
example
Col A Col B
22124 4.20
22124 8.60
22124 9.75
22124 3.15
22125 7.60
22125 26.00
22125 1.78
I want to delete all duplicates in column A but leaving the the row with the lowest numerical value in column B (or extract this information to another sheet).
In the above example I'd be left with:
22124 3.15
22125 1.78
Is there a simple way of doing this? I'm trying to it manually but there are almost 500,000 rows of data!
Any help appreciated.
TIA
Bookmarks