Filter Duplicate Records keeping record with latest date

[LROCCO]

I would like to filter rows for any duplicated records, keeping the
record with the latest date.

For example, I have a list of numbers in row A, with their
corresponding dates (dd/mm/yyyy) in column B. There are duplicates in
column A. I would like to keep the record with the latest date and
then filter the rest

My thanks in advance

 

[JBeaucaire]

1) Sort the two columns by Column A and Column B ascending. This should put
them in the correct order.

2) Assuming the data starts at row2, enter this formula in C2 and copy down
the whole data set:

=A2=A3

You'll now have a set of TRUE/FALSE answers

3) Highlight column C and press CTRL-C to copy

4) Click on EDIT > PASTE SPECIAL > Values

This removes the formulas and leaves the TRUE/FALSE values in

5) Sort the 3 columns again, this time by column C

Now all the FALSE are together...delete all the rows that have TRUE all at
once.

Does that help?

 

[LROCCO]

1) Sort the two columns by Column A and Column B ascending. This should put
them in the correct order.

2) Assuming the data starts at row2, enter this formula in C2 and copy down
the whole data set:

=A2=A3

You'll now have a set of TRUE/FALSE answers

3) Highlight column C and press CTRL-C to copy

4) Click on EDIT > PASTE SPECIAL > Values

This removes the formulas and leaves the TRUE/FALSE values in

5) Sort the 3 columns again, this time by column C

Now all the FALSE are together...delete all the rows that have TRUE all at
once.

Does that help?

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.







- Show quoted text -

Thanks for the reply.

Sorry but I didn't make it clear the first time around. The duplicate
field occurs in column A, i.e. the reference. There should only be
one record with that unique reference number. If for example there
are two records with the same reference, I would like to keep the
record with the latest date, which appears in column B.

I was thinking a macro might be possible??

Cheers