‘壹’ Excel问题~两列数据如何按照一定规律穿插
这族碧样?c1=IF(ROW(A1)>COUNTA(A:B),""兆悔举前戚,IF(MOD(ROW(),3)=0,INDEX(B:B,ROUNDUP(ROW(C1)/3,0)),INDEX(A:A,(ROUNDUP(ROW(C1)/3,0)-1)*2+(MOD(ROW(C1)-1,3)+1))))