How long is this sequence likely to be?
If not too long you could use something like the following and copy it down
the helper column, extending the range to include the cells above in the
helper column for each cell you place it in.

=IF(ISERROR(MATCH(1,A1:A10,0)),"1",IF(ISERROR(MATC H(2,A1:A10,0)),"2",IF(ISERROR(MATCH(3,A1:A10,0))," 3",IF(ISERROR(MATCH(4,A1:A10,0)),"4",IF(ISERROR(MA TCH(5,A1:A10,0)),"5","")))))

"driller2" wrote:


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




--
driller2