Excel: Find missing numbers

I have a range of numbers from, let's say, 1 to 10000. But there are numbers missing. What would be a solution to find the missing numbers and put them in a column?

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of November 11, 2014.

For more resources for Microsoft Excel