I need to be able to identify missing numbers that are in sequential order in column A. I would like to be able to run this so any missing number in column A will generate the missing number(s) in column B for my review.

I have to run this weekly and the starting numbers will change that I start from.

Ex. Week 1
column A Column B
455
456
457
459 458
461 460

Week 2
Column A Column B
15
16
17 18,19,20
21
22
25 23,24

I am using Excel 07 and I have very little experience with Excel.


Any help I can get is greatly appreciated.