•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
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#rows.com#big data management in spreadsheets#conversational data analysis#Excel compatibility#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#data visualization tools#enterprise data management#big data performance#Excel alternatives#data analysis tools#data cleaning solutions#case number#skip detection#sequential numbering#conditional formatting