Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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


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.