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.