Help with Creating Formula to Pull Most Recent Date

[golfer_ld]

Hello,

First time poster trying to get some assistance with a project I am currently working on. Below I have a sample of the data I am trying to manipulate. The goal is to identify the most recent date for any duplicate Client ID's so that those rows can be kept and the others can be deleted. There will be approximately 3000 lines on the file so I am hoping to find a formula so it doesn't have to be gone through manually.

Thanks in advance

12-15-2015 9-05-24 AM.png

[Pete_UK]

Many contributors cannot view .png files on this forum, due to incompatibilities with some browsers - attach a sample Excel workbook instead (the FAQ describes how to).

Pete

[golfer_ld]

Attached is a Workbook since some may not be able to view a .png file

Example.xlsx

[Pete_UK]

I've tried to respond, but the securi firewall won't let me - will try later.

Pete

[Pete_UK]

It really doesn't want me to respond to you, but I'll keep trying.

Pete

[Pete_UK]

You can use this array* formula in D2:

=IF(C2=MAX(IF($A$2:$A$8=A2,$C$2:$C$8)),"okay","remove")

and then copy it down to the bottom of your data. Obviously you should amend the ranges to suit your data.

*NOTE: An array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) rather than the usual |Enter|.

Then you can use a filter on column D to identify those records to be removed.

Hope this helps.

Pete

EDIT: Managed to get it through