=IF(COLUMN()>ROW(),"",COLUMN()&"×"&ROW()&"="&COLUMN()*ROW())
=IF(COLUMN()>ROW(),"",COLUMN()&"×"&ROW()&"="&COLUMN()*ROW())
excel row() or column
row和column是什么意思
=IF(ROW(A1)>7,"",INDIRECT("sheet1!A"&ROW(A1)+COLUMN(A1)*7-7)
=IF($Q17=0,0,INDIRECT(ADDRESS(ROW(),COLUMN()-2,"仕入_"&$Q17)))
=IF(N2="","",OFFSET(INDIRECT($R$1),ROW()-2,COLUMN()-14))
=MOD(-LARGE(COUNTIF($B2:$D6,ROW($1:$9))*10-ROW($1:$9),COLUMN
OFFSET COLUMN OFFSET($A$1,COLUMN()-2,为什么在row的位置填column?
=INDEX($B:$B,SMALL(IF($A$1:$A$17=$D2,ROW($1:$17),4^8),COLUMN
请问数组公式:index($b:$b,small(if(($a:$a=$d2),row(a:a),4^8),column
EXCEL 公式:=INDIRECT("sheet2!"&ADDRESS(ROW(A1),(COLUMN(A1)-1)*
=OFFSET($A$1,ROW(A1)+MATCH($J$10,$A$1:$A$10000,)-2,COLUMN(A1