MrExcelPlayground14.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | List 1 | List 2 | ||||||||
2 | A | 1 | ||||||||
3 | B | 2 | ||||||||
4 | C | 3 | ||||||||
5 | ||||||||||
6 | Output 1 | Output 2 | Output 3 | Output 4 | Output 5 | Output 6 | Output 7 | Output 8 | ||
7 | 1 | A | 1 | A | 1 | A | 1 | A | ||
8 | B | 2 | 2 | B | B | 2 | 2 | B | ||
9 | C | C | C | 3 | 3 | 3 | 3 | C | ||
Sheet17 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A6:H6 | A6 | ="Output " & SEQUENCE(1,2^ROWS(A2:B4)) |
A7:H9 | A7 | =LET(z,A2:B4,x,ROWS(z),y,SEQUENCE(x),a,SEQUENCE(x,2^ROWS(z)),b,SIGN(BITAND(MOD(a-1,2^x)+1,(2^(y-1))))+1,c,INDEX(z,y,b),c) |
Dynamic array formulas. |
Book1 (version 1).xlsb | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | List 1 | List 2 | ||||||||
2 | A | 1 | ||||||||
3 | B | 2 | ||||||||
4 | C | 3 | ||||||||
5 | ||||||||||
6 | Output 1 | Output 2 | Output 3 | Output 4 | Output 5 | Output 6 | Output 7 | Output 8 | ||
7 | A | A | A | A | 1 | 1 | 1 | 1 | ||
8 | B | B | 2 | 2 | B | B | 2 | 2 | ||
9 | C | 3 | C | 3 | C | 3 | C | 3 | ||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A7:H9 | A7 | =LET(rng,A2:B4,r,ROWS(rng),s,SEQUENCE(r),INDEX(rng,s,MID(DEC2BIN(SEQUENCE(,2^r,0),r),s,1)+1)) |
Dynamic array formulas. |