0
Follow
0
View

Repeat value in the next n colums

cyl5331113 注册会员
2023-01-25 21:37

You could try copying this formula down and across starting in C11:

=IF(SUM(INDEX(4:4,MAX(COLUMN($C2),COLUMN()-$B11+1)):C4)=0,"",SUM(INDEX(4:4,MAX(COLUMN($C2),COLUMN()-$B11+1)):C4))

About the Author

Question Info

Publish Time
2023-01-25 21:37
Update Time
2023-01-25 21:37