Hi,

Hoping to get some help on how to write a formula for sequential numbering. I have a file which contains a list of numbers and I want to see where the order breaks.

My first value starts at 533165 and ends at 536370. I've been doing some research and have tried using the following formula but it's not producing the number set I want:

= SMALL(IF(ISNA(MATCH(ROW(A$533165:A$536370),A$533165:A$536370,0)),ROW(A$533165:A$536370)),ROW(A1))

Any suggestions would be greatly appreciated.

Thanks!