Question

EXCEL A1=SHEET1!A1 A3=SHEET1!A2 A5=SHEET1!A3 然后下拉得到A7=SHEET1!A4 A9=SHEET1!A5

Answer 1

A1输入公式
=IF(MOD(ROW(A1),2),OFFSET(Sheet1!$A$1,INT((ROW()-1)/2),),"")
下拉填充

补充内容
A2输入公式
=IF(MOD(ROW(A2),8)=2,OFFSET(Sheet1!$A$3,INT((ROW()-1)/8),),"")
下拉填充

Answer 2

A1 =IF(MOD(ROW(A1),2)=1,OFFSET(Sheet1!$A$1,INT((ROW(A1)-1)/2),),"") 下拉复制公式

追问

A2=SHEET!A3 A10=SHEET!A4 A18=SHEET!A5 麻烦直接给我一个公式被 谢谢

追答

下面这个公式也行
A1 =IF(MOD(ROW(A1),2)=1,INDIRECT("Sheet1!A"&INT(1+ROW(A1)/2)),"") 下拉复制公式

补充你的追问
A2=SHEET1!A3 A10=SHEET!A4 A18=SHEET!A5

A2 =IF(MOD(ROW(A2),8)=2,INDIRECT("Sheet1!A"&INT(3+ROW(A1)/8)),"")