list of pair combination that only use the data once

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

try

Please Login or Register  to view this content.

I have try it and it works!!

thanks for your help!!

I have try it and it works!!

thanks for your help!!

Thanks for the feedback.

That particular code will only work if your range is non-negative integers. No text.
If your numbers are greater than 10,000 you would need to change the b(10000) in the second line.
If your numbers are negative, non-integer, or greater than 10,000,000 then can use a somewhat modified version.

Thanks for the feedback.

That particular code will only work if your range is non-negative integers. No text.
If your numbers are greater than 10,000 you would need to change the b(10000) in the second line.
If your numbers are negative, non-integer, or greater than 10,000,000 then can use a somewhat modified version.

Ok, thanks for the information
I have try changing the number data, and it works!