help pls.

I have a column of text and numbers with something like this

Col. A
1
3
3a
3b
5a
7

I need to gather <among the series the missing numbers in another helper column <note : no decimals, all positive, no gaps...
2
4
6

is there a formula for this in excel ?

thanks in advance...
--
regards