=INDIRECT("R"&INT(ROW(A5)/5)&"C"&MOD(ROW(A5),5)+1
=INDIRECT("R"&INT(ROW(A5)/5)&"C"&MOD(ROW(A5),5)+1
日期:2021-06-17 02:17:14 人气:1
引用R1C1的位置
R向下取整第5行除5&C&第5行除5相除的余数+1
R向下取整第5行除5&C&第5行除5相除的余数+1
=INDIRECT("R"&INT(ROW(A5)/5)&"C"&MOD(ROW(A5),5)+1