Excel如何隔行引用

2025-04-13 10:22:49
推荐回答(1个)
回答1:

竖=OFFSET(Sheet1!$T$3,ROW(A1)*7-7,0)
横=OFFSET(Sheet1!$T$3,COLUMN(A1)*7-7,0)