ExcelBanter - Formula How to add potential nos

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula How to add potential nos (https://www.excelbanter.com/excel-worksheet-functions/78271-formula-how-add-potential-nos.html)

Wilie Loh

Formula How to add potential nos

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

Formula How to add potential nos

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

In article ,
"Wilie Loh" wrote:

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

davesexcel

Formula How to add potential nos

Wilie Loh Wrote:
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 are
asking

--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=524003

All times are GMT +1. The time now is 05:13 AM.