INDIRECT($A$1&"!a"&ROW(2:2)),
=INDIRECT("a"&2*ROW()-1)&INDIRECT("a"&2*ROW())求详解,改能里关系到文字位置
=INDIRECT("a"&INT((ROW()-10)/2)+1)这个公式怎么用
{=indirect("Sheet1!A"&row(1:16))},公式正解.
EXCEL的公式=INDIRECT(INDIRECT("A"&row())啥意思?
请老鸟帮助解释这个公式:=INDIRECT("输入!a"&ROW()*36-2)
求解释在excel中,函数:=INDIRECT("sheet2!A"&((ROW(Sheet2!A2)-2)*20+(C
=SUMPRODUCT(SUMIF(INDIRECT(ROW($1:$2)&"!C:C"),$C5,INDIRECT(R
请一下,您的公式里面=INDIRECT(ADDRESS((ROW(A1)-1)/3+2,MOD(ROW(A1)-1,3)
=IF(ROW(A1)>7,"",INDIRECT("sheet1!A"&ROW(A1)+COLUMN(A1)*7-7)
IF(MOD(ROW(),5),"",INDIRECT("sheet1!a"&ROW()/5) ) 您好,看到您的回答,
解释Excel函数:MATCH(2,LENB(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)
VLOOKUP(B$9&ROW(A1),IF({1,0},$B$2:$B$6&COUNTIF(INDIRECT("b2: