Finding out missing numbers

[kwfine]

Hi all,

I am using Excel 2002.
In a sheet, I have three columns of numeric data as follows:

Column A (registered numbers)
1
2
3
4
5

Column B (random input numbers)
5
4
3
3
3

Column C (absent numbers)
1
2



Description:
Numbers under Column A are registered.
Numbers under Column B are to be checked against those under Column A.
It is clearly that Numbers 1 and 2 are missing, and so they are manually written under Column C.

Question:
In this example, there are only a few numbers used, so we can quickly see that which numbers are missing.
But when the numbers become larger, say a few hundreds, then that will be difficult for human to find out which numbers are missing.
So, I am wondering how to use VB or other Excel functions else to do the
same thing (i.e. to find out which numbers are missing).

Could you help me out please?

Thanks a lot.

Kitty