Find latest date for each ID

[sstephen]

Hello, Can anyone help please?
I have table of 7000 records an each of these has ID (not unique) in column Z and a date in column W).
There are approximately 250 different IDs, therefore some IDs have multiple rows with different dates.
At the end of each row, I would like to display the most recent date for that ID please.

Thanks in advance

Sharon

 

[Peter_SSs]

Welcome to the MrExcel board!

Try a formula like this for row 2 & copy it down to the other rows.
=AGGREGATE(14,6,W$2:W$7000/(Z$2:Z$7000=Z2),1)

 

[sstephen]

Thank you, looks like that worked. You're a star!

 

[Peter_SSs]

Thank you, looks like that worked. You're a star!

You're welcome. Thanks for letting us know.