Hi

I have an XL dbs with approx 7000 records in it. These are a list of
people who have attended training - many of the names and addresses
are duplicated, but column AF contains a date. I need to be able to
remove (or flag) duplicates, but keep the latest dated record for each
person (so we have their most recent address).

So basically I want to keep the most recently dated record for each
person, flagging others as 'old'

Any ideas would be welcome.

I can look at this in either XL2002 or XL 2007, so whichever has the
best feature to solve this.

TIA

Steve