A3=IF(ISERR(INDIRECT("1."&INT(ROW()/3)&"!R"&2+COLUMN()&"C"&CHOOSE(MOD(ROW(),3)+1,2,9,16),)),"",INDIRECT("1."&INT(ROW()/3)&"!R"&2+COLUMN()&"C"&CHOOSE(MOD(ROW(),3)+1,2,9,16),))
向右复制到C3,再向下复制公式。
D3=IF(ISERR(INDIRECT("1."&INT(ROW()/3)&"!R"&55+CHOOSE(COLUMN(A1),0,0,2,4,6,8,11)&"C"&CHOOSE(MOD(ROW(),3)+1,3,10,17)+(COLUMN()=5),)),"",INDIRECT("1."&INT(ROW()/3)&"!R"&55+CHOOSE(COLUMN(A1),0,0,2,4,6,8,11)&"C"&CHOOSE(MOD(ROW(),3)+1,3,10,17)+(COLUMN()=5),))
|