Here's something.........it doesn't deal well with zero or decimals, but
seems to work with whole numbers pretty good...........

=IF(SMALL(F1:K1,2)SMALL(F1:K1,1)+1,SMALL(F1:K1,1) +1,IF(SMALL(F1:K1,3)SMALL(F1:K1,2)+1,SMALL(F1:K1, 2)+1,IF(SMALL(F1:K1,4)SMALL(F1:K1,3)+1,SMALL(F1:K 1,3)+1,IF(SMALL(F1:K1,5)SMALL(F1:K1,4)+1,SMALL(F1 :K1,4)+1,IF(SMALL(F1:K1,6)SMALL(F1:K1,5)+1,SMALL( F1:K1,5)+1,"yuk")))))

Remember, the formula goes all on one line, watch out for email word-wrap.

Vaya con Dios,
Chuck, CABGx3



"Chris_t_2k5" wrote:

Here is my problem,

I have numbers in cells F1:K1 eg, 1,2,3,5,6,7.

Is it possible to have in cell L1 a function / formula to display the
smallest missing number (ie. 4 in the example). The missing number can be
anything upto 15.

Thanks