remove duplicates, keeping latest dated record

S

Steve

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
 
G

Gary''s Student

1. Sort the data first by name then by date (descending)

This will leave you with the data organized by name. So all the Steve
Poster records will be in a contiguous block. Also the first record in the
Steve Poster block will have the most recent date.

2. Create a simple VLOOKUP() table to pull the data. If we VLOOKUP Steve
Poster we will get the first matching recored, which will also be the most
recent data.

A tiny trick, but it should work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter Duplicate Records keeping record with latest date 2
query to retrieve most recent information 3
Selecting last dated training record for each person 2
How can I update the latest cost paid for a part? 2
Keeping latest date field value of duplicates; archiving the rest 0
How do I get just the latest record entry for each grouping by key 3
Trying to pull one record with the most recent date 1
Need to remove duplicates and keep only the highest Status . 2

Top