Compare date time of records among duplicates and only preserve the latest record

[Nirbhay Sharma]

Hi Everyone

i am having a data file which contains records of the service incidents. Now this file records the same incident many times as it keeps a record of every work done towards a request. For every row there a timestamp associated. I need to create a macro to check the latest among the same incident numbers and only preserve that row/record and delete the rest associated with the same row.

Eg:
"INC00000001" has 6 occurances in the sample file. Each occurance has a particular time stamp associated in the system. I need to keep only the occurance with the latest time stamp for INC00000001 and delete the oher occurances of INC00000001. Same process will be followed for every Incident Number and every duplicate.

Can you plz help? Thanks in advance.

 

[Marc L]

Hi,

put your column time stamp in a real date / time format,
sort the list upon this time stamp in descending order
then just use the Excel remove duplicate function …
​