Try this solution:
Assume that your 4 digit No's are in range(A2:An)!
Enter in B2:
=A3A2 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:
> I have a set of randomly generated four digit numbersin ascending order. I
> want to find out and make a list of all the left out 4 digits. Can you help
> me
