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.

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.

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



