My Worksheet contains rows of visits for tests, the result, recall interval for retesting and a cell to indicate if the person returned at the appropriate date. Each person will have multiple entries over time, the records may not be sorted.
I'm trying to create a formula for the ?Returned cell. It needs to test to see if there is a subsequent visit by that person, and if not flag the row for action. I created a list of unique names, with columns containing the row numbers of the matches, but can't get the logic for the test 'is there a subsequent visit'. Thanks