Permutations for 4 columns each of three values

[skinnea]

Hi. I have this data set in cells A1:D4

Effort	Benefit	Alignment	Focus
Low	High	Direct	High
Med	Med	Indirect	Med
High	Low	None	Low

I'd like to determine the (64?) possible permutations, in a single list.

How might I do that with a formula please?

 

[BigBeachBananas]

Are you sure you want permutations or combinations? There's a difference.

 

[skinnea]

Permutations as in Low-High-Direct-High, Low-High-Direct-Medium, etc

 

[Fluff]

Is this what you want?

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Effort	Benefit	Alignment	Focus
2	Low	High	Direct	High		Low	High	Direct	High
3	Med	Med	Indirect	Med		Low	High	Direct	Med
4	High	Low	None	Low		Low	High	Direct	Low
5						Low	High	Indirect	High
6						Low	High	Indirect	Med
7						Low	High	Indirect	Low
8						Low	High	None	High
9						Low	High	None	Med
10						Low	High	None	Low
11						Low	Med	Direct	High
12						Low	Med	Direct	Med
13						Low	Med	Direct	Low
14						Low	Med	Indirect	High
15						Low	Med	Indirect	Med
16						Low	Med	Indirect	Low
17						Low	Med	None	High
18						Low	Med	None	Med
19						Low	Med	None	Low
20						Low	Low	Direct	High
21						Low	Low	Direct	Med
22						Low	Low	Direct	Low
23						Low	Low	Indirect	High
24						Low	Low	Indirect	Med
25						Low	Low	Indirect	Low
26						Low	Low	None	High
27						Low	Low	None	Med
28						Low	Low	None	Low
29						Med	High	Direct	High
30						Med	High	Direct	Med
Data

Cell Formulas
Range	Formula
F2:I82	F2	=INDEX(A2:D4,MID(BASE(SEQUENCE(3^4,,0),3,4),SEQUENCE(,4),1)+1,{1,2,3,4})
Dynamic array formulas.

 

[skinnea]

Is this what you want?

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Effort	Benefit	Alignment	Focus
2	Low	High	Direct	High		Low	High	Direct	High
3	Med	Med	Indirect	Med		Low	High	Direct	Med
4	High	Low	None	Low		Low	High	Direct	Low
5						Low	High	Indirect	High
6						Low	High	Indirect	Med
7						Low	High	Indirect	Low
8						Low	High	None	High
9						Low	High	None	Med
10						Low	High	None	Low
11						Low	Med	Direct	High
12						Low	Med	Direct	Med
13						Low	Med	Direct	Low
14						Low	Med	Indirect	High
15						Low	Med	Indirect	Med
16						Low	Med	Indirect	Low
17						Low	Med	None	High
18						Low	Med	None	Med
19						Low	Med	None	Low
20						Low	Low	Direct	High
21						Low	Low	Direct	Med
22						Low	Low	Direct	Low
23						Low	Low	Indirect	High
24						Low	Low	Indirect	Med
25						Low	Low	Indirect	Low
26						Low	Low	None	High
27						Low	Low	None	Med
28						Low	Low	None	Low
29						Med	High	Direct	High
30						Med	High	Direct	Med
Data

Cell Formulas
Range	Formula
F2:I82	F2	=INDEX(A2:D4,MID(BASE(SEQUENCE(3^4,,0),3,4),SEQUENCE(,4),1)+1,{1,2,3,4})
Dynamic array formulas.

Yes it is ... Is it possible to concatenate the results (ie all 4 words run together for each outcome) so they appear in a single column?

 

[Fluff]

How about

=BYROW(INDEX(A2:D4,MID(BASE(SEQUENCE(3^4,,0),3,4),SEQUENCE(,4),1)+1,{1,2,3,4}),LAMBDA(br,CONCAT(br)))