Formula How to add potential nos

[Wilie Loh]

How to add potential nos to list in table but append to columns

2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....
1248
0169
0367
0468
1256
1267
1368
3889
4999
5568
6777
0148
0889
1146
1235
1357
1477
1489
4579
4668
4899

 

[JE McGimpsey]

How would XL know which "potential numbers" should go in adjacent
columns?

 

[davesexcel]

How to add potential nos to list in table but append to columns

2499 ---> 2899 or 2199 or 2466 or 5499
3678 ---> 3675 or ....
1248
.....
4899

Is there a formula you are asking for? I don't know what you ar
askin