Thanks heaps for the quick response, similar to what I am after.

However I have over 300 numbers that run down the column A and only 200 down column B. I need to be able to quickly depict which numbers are missing as oppoed to having to work out which numbers do not exist in the sequence once that formula is inserted.