REmoving duplicates formula?

ef112_ePDM%20Checking%20Tool(1).xlsxPete, you're a star, that's a lovely formula. When i paste another list in A tho it's giving me a space in C3. I need the formula to remove any spaces from the list. I've attached the file!

You also have a zero at the end of the list - this is because you've extended the range to row 3000, where you have real blanks (empty cells).

One way of getting rid of the empty cell would be to apply an auto-sort formula in column D, which would also sort the extracted unique numbers in order.

I'm a bit busy at the moment, though, so maybe someone else will chip in.

Pete