You're not accounting for the letters in the cells.

--
Biff
Microsoft Excel MVP


"Teethless mama" wrote in message
...
"numbers" is a defined name range

=SMALL(INDEX((COUNTIF(numbers,ROW(INDIRECT(MIN(num bers)&":"&MAX(numbers))))=0)*ROW(INDIRECT(MIN(numb ers)&":"&MAX(numbers))),0),ROWS($1:1)+COUNT(number s))

copy down as far as needed


"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