Use a help column, assume the values are in A1:Awhatever, in B1 put

=RIGHT(A2,5)-RIGHT(A1,5)<1


copy down as long as needed, now every string that is followed by a string
that is not increased by 1 will be tagged with TRUE

now you can filter on the TRUE if you want


--
Regards,

Peo Sjoblom



"Jeanette" wrote in message
...
SP-07-00001 to SP-07-09524 etc

"T. Valko" wrote:

Be more specific:

'very' large - 500 rows? 5,000 rows? 50,000 rows?

Continuous numbers - From 1 to 500? From 1 to 5,000? From 1 to 50,000?

Biff

"Jeanette" wrote in message
...
I am currently working with a 'very' large data base, that has a column
of
Continuous numbers, is there a way in excel to find the breaks in the
Continuous numbering?