第1个回答 2021-05-27
使用下列公式之一
=IF(INDEX(B:B,ROW(A1)*3-1)=0,"",INDEX(B:B,ROW(A1)*3-1))
=IF(INDIRECT("B"&ROW(A1)*3-1)=0,"",INDIRECT("B"&ROW(A1)*3-1))
=IF(OFFSET(B$1,ROW(A1)*3-2,)=0,"",OFFSET(B$1,ROW(A1)*3-2,))下拉填充
第2个回答 2021-05-26
=IF(INDEX(B:B,(ROW(A1)-1)*3+2)=0,"",INDEX(B:B,(ROW(A1)-1)*3+2))