A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
CODE FOR PERMUTATIONS & COMBINATIONS
Any valid code for Excel 2010 available for:
- Listing all the possible Permutations & Combinations;
- Of relevant/selected cells;
- FROM a specific minimum size of items;
- TO a maximum size of items?
For example:
With the data being simply five cells as:
A B C D E
Minimum Size being:
2
Maximum Size being
3
Result of PERMUTATIONS resulting to be:
A B
A C
A D
A E
B A
B C
B D
B E
C A
C B
C D
C E
D A
D B
D C
D E
E A
E B
E C
E D
A B C
A B D
A B E
A C B
A C D
A C E
A D B
A D C
A D E
A E B
A E C
A E D
B A C
B A D
B A E
B C A
B C D
B C E
B D A
B D C
B D E
B E A
B E C
B E D
C A B
C A D
C A E
C B A
C B D
C B E
C D A
C D B
C D E
C E A
C E B
C E D
D A B
D A C
D A E
D B A
D B C
D B E
D C A
D C B
D C E
D E A
D E B
D E C
E A B
E A C
E A D
E B A
E B C
E B D
E C A
E C B
E C D
E D A
E D B
E D C
And,
Result of COMBINATIONS resulting to be:
A B
A C
A D
A E
B C
B D
B E
C D
C E
D E
A B C
A B D
A B E
A C D
A C E
A D E
B C D
B C E
B D E
C D E
Thanx in advance!
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.