I have a range of numbers in column A which started with number 2 through 65535. This range is missing numbers. (For instance, numbers 1, 6, and 7, are missing from this range.

What we want to know is using Excel 2003, steps on How to Set up a Formula that will either highlight the missing numbers from a complete "non-gapped range of numbers" in column B, or either a formula that will tally Column A and place missing numbers (gaps) in another column.

Again, our range starts like:

2
3
4
5
8
9
10
12
14
15
16
17
18
19
20
22
26
28
29

So we know card 1, 6, 7 13, 21 23, 24, 25 and 27 are not in column A. Our range is a 2000 count range so we can't sit and manually count what is missing. Your help with a formula would help me tremendously.