Maybe try DataSort:
Select Rego# ascending, then by RegoDate descending, and click OK.

Now select Rego# column, DataFilterAdvanced Filter:
Check options Filter the list in Place, unique values, and click OK.

This will show latest RegoDate for each Rego#.
(Do this on a copy of the sheet or add a row identifier to keep original
order.)

"Sklyn" wrote:

Hi, I have multiple entries in column A with different information accross
the row (including dates). i want to filter for only the most recent ones..
e.g.
Rego# RegoDate
123-456 29/09/09
123-456 29/09/08
123-456 29/09/07
789-123 29/09/09
789-123 29/09/08

I only want to see the most recent entry of each Rego#