goodwillhunting
New Member
- Joined
- Mar 22, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi All
I have a set of combination of 3 numbers as shown below, in column A1 of an excel worksheet
1,2,4
1,2,5
1,3,4
1,3,5
1,4,5
2,3,5
2,4,5
Please create an excel vba program to convert the above combinations to the possible combination of 4 numbers in such a way that the original 3 number combinations are the subsets of the new 4 number combination.
The answer that I should get is this
1,2,4,5
1,3,4,5
1,2,3,5
Thanks in advance for your help.
Regards
Goodwill Hunting
I have a set of combination of 3 numbers as shown below, in column A1 of an excel worksheet
1,2,4
1,2,5
1,3,4
1,3,5
1,4,5
2,3,5
2,4,5
Please create an excel vba program to convert the above combinations to the possible combination of 4 numbers in such a way that the original 3 number combinations are the subsets of the new 4 number combination.
The answer that I should get is this
1,2,4,5
1,3,4,5
1,2,3,5
Thanks in advance for your help.
Regards
Goodwill Hunting