=ROUND(LARGE($B$3:$B$11-ROW($B$3:$B$11)/1000000,ROW(2:2)),3)
=IF(MOD(ROW()+1,3)=0,INDEX(B:B,ROW()+4)/3,
关于=INDEX(D:D,SMALL(IF($B$3:$B$11=$B$15,ROW($B$3:$B$11),65536
IF(MOD(ROW(),3)=1,a,IF(MOD(ROW(),3)=2,b,""))这个函数怎么解
A is in class 3,row 2,B is in class 4,row 2, Can we say they
excel中 =CHOOSE(MOD(ROW(B4),3)+1,"",B$1,OFFSET(B$1,ROW(B5)/3,
=INDEX(AA!H:H,SMALL(IF(AA!$B$2:$B$2001=$C$3,ROW($2:$2000),4^
=IF(MOD(ROW(),3)=0,"",IF(MOD(ROW(),3)=1,Sheet1!B$1,INDEX(She
row()-1 =IF(ROW()>SUM(IF($B$2:$B$10=$E$2,1,0))+1,"",INDEX($C
=SUM(INDIRECT("B1:B"&ROW())),
公式 =INDIRECT($B$3&"!"&"C"&ROW(3:3)+5)&"" 帮我解释一下是什么意思
谁能看懂这个函数公式吗?=INDIRECT(CONCATENATE("汇总表!B",1+ROW()*3),TRUE)
=SMALL(IF(COUNTIF($B$2:$B$14,$D$2:$D$14),ROW($B$2:$B$14),655