Forum Discussion
Highlight missing sequential number
How do I check for missing numbers is Excel? Current numbers should be sequential and I want Excel to tell me is there is a missing number.
2 Replies
You could use a formula in either a helper column or conditional format. Say your data is in A2:A10 (A1 is a header), then try this formula in B2 and copy down. Or, you could select A2:A10 and use the formula in conditional format to highlight non-sequential entries.
=IF(ROW($A2)>ROW($A$2),$A2-1<>$A1)
IMHO, more simple CF formula =$A2<>$A1+1 shall work.
