Ok, sort them as i suggested then in another column put this formula

=IF((a1+1)=a2,,"X")

every time the run of numbers breaks you will get an X in the column. Then if you want to find a large row of numbers you can just look down untill you hit an X. If that isn't automated enough you could put a lookup table or simmilar in to collect each number that corresponds to an X.