excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
hi!
how can i fill down this formula with jumps of rows? (don't know how phrase it so i called it jumps)
so the next formula will applied on a4:f4
than on a5:f5
and so on...
how can i fill down this formula with jumps of rows? (don't know how phrase it so i called it jumps)
so the next formula will applied on a4:f4
than on a5:f5
and so on...
test | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | |||||||||||
2 | 1 | 2 | 3 | 4 | 5 | 6 | 1-2-3-4-5 | ||||
3 | 3 | 5 | 6 | 7 | 8 | 9 | 1-2-3-4-6 | ||||
4 | 11 | 12 | 13 | 14 | 15 | 16 | 1-2-3-5-6 | ||||
5 | 14 | 15 | 16 | 17 | 18 | 19 | 1-2-4-5-6 | ||||
6 | 1-3-4-5-6 | ||||||||||
7 | 2-3-4-5-6 | ||||||||||
8 | 3-5-6-7-8 | ||||||||||
9 | 3-5-6-7-9 | ||||||||||
10 | 3-5-6-8-9 | ||||||||||
11 | 3-5-7-8-9 | ||||||||||
12 | 3-6-7-8-9 | ||||||||||
13 | 5-6-7-8-9 | ||||||||||
14 | |||||||||||
15 | |||||||||||
test |
Cell Formulas | ||
---|---|---|
Range | Formula | |
I2:I7 | I2 | =LET(d,TOROW(A2:F2,1,1),N,5,c,COUNT(d),x,BYROW(IF(MOD(INT(SEQUENCE(2^c,,0)/2^SEQUENCE(,c,0)),2),d,""),LAMBDA(r,IF(COUNT(r)=N,TEXTJOIN("-",,r),""))),FILTER(x,x<>"")) |
I8:I13 | I8 | =LET(d,TOROW(A3:F3,1,1),N,5,c,COUNT(d),x,BYROW(IF(MOD(INT(SEQUENCE(2^c,,0)/2^SEQUENCE(,c,0)),2),d,""),LAMBDA(r,IF(COUNT(r)=N,TEXTJOIN("-",,r),""))),FILTER(x,x<>"")) |
Dynamic array formulas. |