The pickup log contains R-11, R-12, R-11, R-14, and R-15. You need the IDs with just one occurrence, which can help identify a missing second entry.
Set exactly_once to TRUE
Put the IDs in A2:A6. In a dynamic-array editor, enter =UNIQUE(A2:A6,FALSE,TRUE) in an empty area. The result should be R-12, R-14, and R-15. Compare with =UNIQUE(A2:A6), which includes R-11 once in the distinct list.

Illustrated comparison of UNIQUE modes. Start with a deliberate repeat.
Change one occurrence and check the result
Replace R-15 with R-14 in a copy. Only R-12 should remain in the singleton list. Before treating any singleton as missing an event, confirm the log is complete and inspect identifiers for extra spaces or inconsistent spelling.

Illustrated count change. Confirm that the log contains all relevant events.



