I have a huge list of data in excel (250.000+ rows) in the following format:
Number Value1 Date Value2
40325 1 21/01/11 18.10 2
65485 3 22/01/11 16.47 2
40325 9 25/01/11 19.00 0
70912 8 27/01/11 16.43 2
I need to remove duplicate rows based on column 1 (Number), and have no problem doing this using "Data/Remove Duplicates" in Excel, but I need to make sure that I remove the row with the oldest date, and keep the newest, based on column 3 (Date).
In the example above, I would need to remove row 1 and keep row 3, since row 3 is the newest.
I have 4.800 rows with duplicates, so a manual sorting/removing would be a very time consuming job.
Any good suggestions? And tricks to help me out? Thanks a lot in advance :)