•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to determine if any numbers in a series were skipped
Our take
Managing sequential case numbers often becomes a challenge when legacy methods fail to flag missing entries. While conditional formatting identifies duplicates, detecting skipped numbers requires a more proactive approach to data integrity. By implementing a targeted formula on Sheet 1, you can automatically identify gaps in your numbering series and ensure your records remain complete. To further optimize your automation strategy, you might also explore our guide on whether to shift to Office Scripts for modern workflows.
In column J of my main data entry sheet, I have a series of case numbers. They all begin with 4 digits for the year, followed by a dash (-), and then 3 digits for the case number (sample: 2026-001, 2026-002, etc). They're supposed to be used consecutively. Each year begins again at '-001'. I have a conditional formatting rule to highlight the number if it has already been used, but now I need a way to determine if a number was skipped. I want the results to be reflected on 'Sheet 1'.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience