Identify missing numbers

[tip]

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.

[MickG]

Hi, Try this.
List in column "A", as yout post.
Results in column "B" as required.

Please Login or Register  to view this content.

Regards Mick

[tip]

I hate to ask but can you explain how to use/run this code.

Thanks

[tip]

I got it to work. Thanks so much.