How do I find a range of numbers in an Excel file?

all you want to do is find consecutive #'s

i will assume the sample given is a good sample, and give a basic formula.

- assume the sample starts in cell A1

- copy&paste this in B2 (yes B2 not B1)

=IF(A1+1=A2,"this is a consecutive number","")

you should get a blank.

drag the cell down,

or copy the cell

select 5000 rows below

click paste

most cells will be blank.

whenever theres a consecutive number, then column B will show a note.

you can expand the formula to make it do what you want.

you can start in Row#2 and turn on the autofilter.

let me know how it works.

It will take you less time to do it manually.