EXCEL转置
A2=OFFSET(O$1,ROUNDUP(ROW(A1)/9,),)
B2=OFFSET(R$1,ROUNDUP(ROW(B1)/9,),)
H2=OFFSET($X$1,ROUNDUP(ROW(A1)/9,),MOD(ROW(A1)-1,9),)
M2=IF(MOD(ROW(),9)=1,SUM(OFFSET(D2,,,-9)),"")
N2=IF(MOD(ROW(),9)=1,OFFSET(AG$1,ROUNDUP(ROW(A1)/9,),),"")
均下拉复制(黄色区域)
。
A2=OFFSET(O$1,ROUNDUP(ROW(A1)/9,),)
B2=OFFSET(R$1,ROUNDUP(ROW(B1)/9,),)
H2=OFFSET($X$1,ROUNDUP(ROW(A1)/9,),MOD(ROW(A1)-1,9),)
M2=IF(MOD(ROW(),9)=1,SUM(OFFSET(D2,,,-9)),"")
N2=IF(MOD(ROW(),9)=1,OFFSET(AG$1,ROUNDUP(ROW(A1)/9,),),"")
均下拉复制(黄色区域)
。
收起