How Do You Find a Missing Number?
Understand the full background How Do You Find a Missing Number with clear explanations.
1. Select the sequence and click Kutools > Insert > Find Missing Sequence Number. 2. In the Find Missing Sequence Number dialog, check Inserting blank rows when encountering missing sequence numbers option. See screenshot: 3. Click Ok, then a popping dialog tells you the number of missing numbers, click OK to close it.