I have a table of data that contains a column with a unique property code ID,
(say Column X) and a column that contains a date on which periodic
maintenance (with a unique name) was completed (say Column Z). This data is
pulled from the server into Access and exported to Excel, based on whatever
date parameters I specify. Most of the time, I will get some duplication of
properties that may have several dates for the same type of maintenance. What
I want to do in Excel is parse out (or delete from the list) all the
duplicate properties, leaving only the one with the latest date, and, of
course, leaving all the other properties that have only one date listed. Is
that possible with VBA?

--
DPCpresto

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200907/1