Possible combinations of 7 numbers (non repeated)

[maheshmaxi]

Hi

Can anyone help me with the list of possible combinations of 7 numbers (non repeated)

 

[Special-K99]

Dunno if this works but it looks intriguing.

Create all possible combinations from different ranges without using VBA

 

[XOR LX]

Hi,

What are you considering "all possible combinations"? All combinations consisting of 7 numbers? Or do you also want groupings of 1, 2, 3, etc. numbers from those 7?

For example, if the numbers were 1, 2, 3, 4, 5, 6 and 7, would you want to see:

1
2
3
4
5
6
7
1 2
1 3
1 4
1 5
1 6
1 7
2 3
2 4
...

etc.?

Or just the seven-digit numbers?

Regards

 

[maheshmaxi]

Thanks for your response. Yes exactly the same way. Result should be all the digits (between 1 and 7) in different combination (not repeated).

 

[XOR LX]

What do you mean by "not repeated"? And are your numbers in reality all single-digit numbers?

Regards

 

[maheshmaxi]

Hi XOR LX,

Sorry, I confused you just by mentioning it "not repeated", just to avoid 22, 223, 343, 1211, etc. I need it in the same way you have mentioned. But I am struggling to get it in excel. Even though if i get the values with repeated numbers into single cell, I have no issues. I will remove it using formulas

1
2
3
4
5
6
7
1 2
1 3
1 4
1 5
1 6
1 7
2 3
2 4
...

 

[XOR LX]

But what are your actual numbers in question? Are they 1, 2, 3, 4, 5, 6 and 7? Or other single-digit numbers? Or can they be of any length?

Do any of the numbers in your original list occur more than once in that list?

I think you need to try to be a bit clearer about what data you have and what you would like to see as a result.

Regards

 

[maheshmaxi]

Actually we compared two different tables with big data, each table contains 7 columns: Name, Age, Address, City, etc. While comparing not all the columns match for a record.
I am building a combination table for my "Match_Result" column, which will have combination of matches like below:

Name, Age & City
Name & Age
Name & City
City
Address & City
Age & City

 

[XOR LX]

Could you please give an example of what results you actually want to generate?

Regards