| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing duplicate records based off of date
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing duplicate records with long names in Excel 2007 | Excel Discussion (Misc queries) | |||
| Delete records when certain records have duplicate column data | New Users to Excel | |||
| Removing all duplicate records except one copy | Excel Discussion (Misc queries) | |||
| removing duplicate records in excel, how to do it? | Excel Discussion (Misc queries) | |||
| In Excel, how do I get rid of duplicate records? Based on text r. | Excel Discussion (Misc queries) | |||
Threaded Mode
