Originally Posted by p45cal

In the attached is a Power Query offering at cell F1 of the Registration sheet. It just needs right-clicking and refreshing. It lists only those registrations not renewed in the current year without a comment attached to the latest registatrion (it will still list a non-renewal if there's no comment attached to the latest renewal) and only lists the latest registration for each registration.