Is there a way to look at a group of records where some have been duplicated
and for those that are duplicated , keep the most current date (keeping that
row of data)?
The records have a unique record number to identify if record is a
duplicate and I also have a record month/yr which would be different for the
duplicate records, please see example.. Note there are additional columns but
did not think necessary to list for the example.
I am also using Excel 2007

record # record month/yr
RT123 10/1/2009
RT123 11/1/2009
RT123 1/1/2010
MT122 10/1/2009
MM121 10/1/2009
NM119 1/1/2010

Final Result I am looking for:

record # record month/yr

RT123 1/1/2010
MT122 10/1/2009
MM121 10/1/2009
NM119 1/1/2010

Thank you in advance for any assistance.