F1=IFERROR(INDEX(OFFSET($A$1,$C$1-1,,$D$1-$C$1+1,),ROW(A1)),"")向下复制
F1输入:=IF(ROW(A1)<=D$1-C$1+1,INDIRECT("A"&C$1+ROW(A1)-1),"")下拉公式