Formula to show Latest Date @row

A Rose

Hi,

I have a column that has a list of customers and date column next to that, each client is there a few times because they have a few dates,

Any formula to only see the latest dates, so I can delete the others?

Thank you!

Kimberly Loveless

What I have done based on historical community questions on finding the most recent entries is

• Add an Auto-Number column (any format)
• Add text/number column called "Row #" with the formula below entered in it

=MATCH([Auto-Number]@row,[Auto-Number]:[Auto-Number],0)

• Add checkbox column with the formula below in it (this will check the box of the most recent entry)

=IF([Row #]@row=MAX(COLLECT([Row #]:[Row #],[Client Name]:[Client Name], [Client Name]@row)),1)

There is probably an easier way, that is just the one that worked best for me when I was looking a few months back for a way to indicate the most recent entry