Quote:
Originally Posted by Purfleet
possibly with advanced filter or PQ
|
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.