Try this solution:
Assume that your 4 digit No's are in range(A2:An)!
Enter in B2:
=A3-A2 and fill it down as necessary
in C2:
=IF($B2=1,"",IF($A2+CELL("column",C$1)-2<$A3,$A2+CELL("column",C$1)-2,""))
and fill it right to last column (IV), and down as necessary!
In columns C:IV you get the left out . To say the truth there is a limit of
this solution: if more then 254 4 digits miss between two random No, then
those above 254 will not appear in the list!
Regards,
Stefi
„B.H. Hadi†ezt Ãrta: