Perhaps a relationship will serve.
You may need more fields to reference the correct group of records but
Table::cYes = Table 2::Response And
Table:: PersonID ≠ Table 2:: PersonID
cYes is a calculation field with "yes" as it's calculation so that all records have the same value, yes, in this field. Table 2 is a second table occurrence of table.
Can be used to point to all the records where "Yes" was the response except for the current record. Last ( Table2::field ) can refer to the most recent record other than the current record where someone responded "yes".