Need Help Identifying missing numbers

[christiangray]

Hi Guys,

I have a list of job numbers from my work in an excell file and I need to find a code to write to identify the missing ones.

It is just a list starting at 2489 and going through 33747.

Any help would be great.

Thanks

[DGagnon]

are you comparing 2 lists? or do you just have a number range and need to find what numbers in that range are not included in the list?