本帖最后由 我走我流 于 2019-11-22 16:43 编辑
=IFERROR(IF(OR(COLUMN(A1)>INT($D$4/2),SUM((ROW(A1)=MMULT(N(COLUMN($A:$C)<=ROW($1:$3)),CEILING($D$4:$D$6,INT($D$4/2))/INT($D$4/2)))*(MOD(COLUMN(A1)-1,INT($D$4/2))>MOD($D$4:$D$6-1,INT($D$4/2))))),"",VLOOKUP(MOD((ROW(A1)-1)*INT($D$4/2)+COLUMN(A1)-1,CEILING($D$4,INT($D$4/2)))+1,OFFSET($P$4,,MATCH(INDEX($C$4:$C$6,MATCH(,0/((ROW(A1)-1)*INT($D$4/2)+COLUMN(A1)<=MMULT(N(COLUMN($A:$C)<=ROW($1:$3)),CEILING($D$4:$D$6,INT($D$4/2)))),)),$Q$3:$Y$3,)-1,10,2),2,)),"")
配合条件格式
=IFNA(IF(COLUMN(A1)>INT($D$4/2),1/0,IF(SUM((ROW(A1)=MMULT(N(COLUMN($A:$C)<=ROW($1:$3)),CEILING($D$4:$D$6,INT($D$4/2))/INT($D$4/2)))*(MOD(COLUMN(A1)-1,INT($D$4/2))>MOD($D$4:$D$6-1,INT($D$4/2)))),"",VLOOKUP(MOD((ROW(A1)-1)*INT($D$4/2)+COLUMN(A1)-1,CEILING($D$4,INT($D$4/2)))+1,OFFSET($P$4,,MATCH(INDEX($C$4:$C$6,MATCH(,0/((ROW(A1)-1)*INT($D$4/2)+COLUMN(A1)<=MMULT(N(COLUMN($A:$C)<=ROW($1:$3)),CEILING($D$4:$D$6,INT($D$4/2)))),)),$Q$3:$Y$3,)-1,10,2),2,))),1/0)
|