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:

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