The ticket export jumps from 102 to 105. Check neighboring rows in numeric order to separate gaps from repeated IDs.

Compare each ticket with the one above it

In a working copy, sort complete records by numeric ID. For the sample, enter 101, 102, 105, 105 and 106 in A2:A6. Leave B2 empty and enter this in B3:

=IF(A3=A2,"Duplicate",IF(A3-A2>1,A3-A2-1,""))

Fill down. The first 105 gives 2 because 103 and 104 are absent. The second 105 gives Duplicate.

Sorted IDs 101, 102, 105, 105 and 106 contain a gap before the first 105.

Illustrated adjacent comparison. Sort whole records together.

Confirm what the gap represents

Compare with the unfiltered export or source system before reporting missing records. A number may have been voided, filtered out or assigned to another series. Keep different prefixes in separate runs and preserve original IDs with any leading zeros.

The first 105 is flagged for two missing IDs and the second 105 is a duplicate.

Illustrated gap report. Check the unfiltered source before treating either as lost data.