Share via

CODE FOR PERMUTATIONS & COMBINATIONS

Anonymous
2011-10-10T06:51:43+00:00

Any valid code for Excel 2010 available for:

  1. Listing all the possible Permutations & Combinations;
  2. Of relevant/selected cells;
  3. FROM a specific minimum size of items;
  4. 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.

0 comments No comments