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.

The distinct list includes R-11 once, while the singleton list excludes it.

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.

Changing R-15 to R-14 leaves R-12 as the only singleton.

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

Microsoft’s UNIQUE function reference