Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have data as noted in example below and I need to remove duplicate values retaining the latest updated value and remove the data that is in bold and italics

Time Delivered Time Difference Name Order #

4/1/2011 21:25 9:04:23 Hilton, Kevin M. f0000865

4/1/2011 13:31 1:10:23 Hilton, Kevin M. f0000865

4/1/2011 19:30 7:09:57 Hilton, Kevin M. f0000864

4/1/2011 13:31 1:10:57 Hilton, Kevin M. f0000864

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Sort your data by Time Delivered descending (newest first), then remove duplicates from the table using Order# as the only criterion. That should work because the Remove Duplicates function keeps the first unique record from the top and removes duplicates that follow.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.