如何,使得我的excel中的数据B列中的4,5行分别=A9,A10, B6,B7=A17,A18 B7,B8=A25,A26 ...... ----------

=INDEX(A:A,INT(ROW()/2-1)*8+ROW()-INT(ROW()/2-1)*2-1)

Published At2006-01-01 13:53 UTC