五需求 自動產生字符串 (14752)

D2=IF((COLUMN(A1)>$B$5)+(ROW(A1)*$B$5-$B$5+COLUMN(A1)>$B$8),"",$B$2&$B$14&RIGHT(REPT(0,9)&ROW(A1)*$B$5-$B$5+COLUMN(A1),$B$11))



留言