|
试试这个笨办法
在B2中输入
=IF(OR((ROW()-1)/4-TRUNC((ROW()-1)/4)=0,AND(IF((ROW())/4-TRUNC((ROW())/4)=0,16,IF((ROW()+1)/4-TRUNC((ROW()+1)/4)=0,8,2))=2,COLUMN()>6),AND(IF((ROW())/4-TRUNC((ROW())/4)=0,16,IF((ROW()+1)/4-TRUNC((ROW()+1)/4)=0,8,2))=16,COLUMN()>4),INDIRECT("Sheet2!"&ADDRESS((CEILING(ROW(A2)-1,4)/4)+1,COLUMN(Sheet2!A2)+IF((ROW())/4-TRUNC((ROW())/4)=0,17,IF((ROW()+1)/4-TRUNC((ROW()+1)/4)=0,9,3))))=0),"",INDIRECT("Sheet2!"&ADDRESS((CEILING(ROW(A2)-1,4)/4)+1,COLUMN(Sheet2!A2)+IF((ROW())/4-TRUNC((ROW())/4)=0,17,IF((ROW()+1)/4-TRUNC((ROW()+1)/4)=0,9,3)))))
然后向右拖7列再向下拖
式子真的令人见笑,我自己看到都头晕,人笨没办法,能达到效果就可以。 |
|