=INDIRECT("R"&INT(ROW(A5)/5)&"C"&MOD(ROW(A5),5)+1

日期:2021-06-17 02:17:14 人气:1

=INDIRECT("R"&INT(ROW(A5)/5)&"C"&MOD(ROW(A5),5)+1

引用R1C1的位置
R向下取整第5行除5&C&第5行除5相除的余数+1
    A+
热门评论