Find Next True And The Matching Records Above And Below – 2480

Michele has 46000 rows of data. Each ID has several records in a row. Many records are marked as “Changed”. When there is a change, Michele needs to check the record marked, plus the matching IDs just above and below.

In this video, I try Find All and 2 Advanced Filters. I bet you have something better.