So generally when using the remove duplicates function in Excel the oldest record will be kept - and that's exactly what I want to happen!

But recently when running Remove Duplicates, it is automatically deleting the oldest entry and keeping the new one -- which is messing up my data collection.

Please can you advise how to get Excel to keep only the oldest entry?