OFFSET函数详解:
=OFFSET(reference,rows,cols,height,width)
=OFFSET(参考系或参考区域,向下移动行数,向右移动列数,取值行数,取值列数)
Reference:参考系或参考区域
Rows:向下移动行数;
Cols:向右移动列数;
Height:取值行数;
Width:取值列数;
https://jingyan.baidu.com/article/9f7e7ec0bc43b76f281554b4.html
OFFSET函数详解:
=OFFSET(reference,rows,cols,height,width)
=OFFSET(参考系或参考区域,向下移动行数,向右移动列数,取值行数,取值列数)
Reference:参考系或参考区域
Rows:向下移动行数;
Cols:向右移动列数;
Height:取值行数;
Width:取值列数;
https://jingyan.baidu.com/article/9f7e7ec0bc43b76f281554b4.html