View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris_t_2k5
 
Posts: n/a
Default smallest missing number

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