Hey All,

I have a column of numbers like in the example I made. I want to make list of pair combination using macro, with condition that the difference value are <=100, but the number in the column only can be chosen once.

Can someone help me with this? Thank you.. I really appreciate it

Example :

Data Column
700
500
600
800
900
1300
1100
1200
1500
1550
1600

list of pair :

700 600
800 900
1300 1200
1500 1550