I have a table that contains data from columns A:H.
Column B is a Date Field (Short Date Format= mm/dd/yyyy)
Column C is an alpha numeric field (Text Format)
There can be duplicate values in column C, but each record will have a different date. For Example, let's say I have the following records:
Row # Column B Column C
1 03/25/2013 11030
2 05/07/2013 11030
3 07/01/2013 11030
In this example, I want to only keep Row #3 as this record has the most recent date. The number "11030" has been duplicated 3 times. So my criteria for deleting duplicates is to keep the duplicated record which has the most recent date and this code needs to cycle through the data set to find the duplicates and ONLY keep the most recent date. Something to keep in mind while developing this code: I have seen 2-6 duplicate records. Please help! I do not want to have to do this manually by hand as there's thousands of records to go through! Any help will be greatly appreciated.