Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .