EXCEL ｛=MATCH(LARGE((D5:AR5)*10^6-COLUMN(D5:AR5),3),D5:AR5*10^6-COLUMN(D5:AR5),0)｝这个公式怎么解释?1、LARGE((D5:AR5)*10^6-COLUMN(D5:2、D5:AR5*10^6-COLUMN(D5:

EXCEL ｛=MATCH(LARGE((D5:AR5)*10^6-COLUMN(D5:AR5),3),D5:AR5*10^6-COLUMN(D5:AR5),0)｝这个公式怎么解释?1、LARGE((D5:AR5)*10^6-COLUMN(D5:2、D5:AR5*10^6-COLUMN(D5: EXCEL =INDEX(A:A,MATCH(1,1*(B2:B30 求问一个EXCEL函数意义.=IF(ROW(A1)>D$2,,INDEX(A:A,MATCH(LARGE(IF((B$2:B$100>0)*(B$2:B$100>=LARGE(B$2:B$100,D$2)),B$2:B$100-ROW($2:$100)/10^8,),ROW(A1)),B$2:B$100-ROW($2:$100)/10^8,)+1)) 有没有人知道excel函数 D2=INDEX($A$2:$C$33,MATCH(LARGE((MID($A$2:$A$33,5,1)=1)*$C$2:$C$33-ROW($A$2:$A$33)/100,ROW(A1)),$C$2:$C$33-ROW($A$2:$A$33)/100,0),) 中MATCH(LARGE((MID($A$2:$A$33,5,1)=1)*$C$2:$C$33-ROW($A$2:$A$33)/100 的 帮忙解释一下这个强悍的EXCEL函数公式啥意思?=INDEX(Sheet1!$A:$A,MATCH(LARGE(Sheet1!$B$2:$B$500+1/ROW(Sheet1!$B$2:$B$500)*0.000001,ROW(A1)),Sheet1!$B$2:$B$500+1/ROW(Sheet1!$B$2:$B$500)*0.000001,0)+1)讲的越细越好, excel公式 =ISERROR(MATCH($A1,B:B,0)) 啥意思 请解释ISERROR用法 EXCEL里,一列中最大的10个数相加的公式是多少?（比如A列有100个数,取其中最大的10个数,并相加）=large（A:A,1）+large（A:A,2）+large（A:A,3）+large（A:A,4）+large（A:A,5）+large（A:A,6）+large（A:A,7）+large 关于EXCEL中的MATCH和INDEX函数{=INDEX(B2:B21,MATCH(MIN(D2:D21),D2:D21,0))}和{=INDEX(E2:E21,MATCH(MIN(IF(H2:H21=女,D2:D21,TODAY())),D2:D21,0))} excel中match函数请帮我解析一下这两个函数的区别; If(match(A2,A1:A9,0),”once”,''dobule”)If(match(A2,A2:A9,0)=Row()-1,”once”,''dobule”) 请问这个excel函数公式=CHOOSE(MATCH(MAX(1-F1,1-G1),{-5,0,0.2,0.3}),0.05,0.02,0.015, EXCEL一个语句的意思,=IF(ISTEXT(C6),OFFSET('ASSY NUMBER'!$G$4,MATCH(C6,RngProductNumber,0),1),) 谁能解释下（excel函数）=IF(ISNA(MATCH(C2,2010!$D$5:$D$68,0)),IF(ISNA(MATCH(C2,2010!$E$5:$E$68,0)),IF(ISNA(MATCH(C2,2009!$D$5:$D$44,0)),IF(ISNA(MATCH(C2,2009!$E$5:$E$44,0)),,INDIRECT(2009!B&MATCH(C2,2009!$E$5:$E$44,0)+4)),INDIRECT(2009!B EXCEL 请解释=INDEX(1:1,RIGHT(LARGE($B2:$H2/1%+COLUMN($B:$H),COLUMN(A1))))是什么意思 在excel中函数index和函数match怎么应用, 关于EXCEL中,INDIRECT和MATCH函数的使用IF($A5=,,INDIRECT('&B$2&'!C&MATCH(合 计,INDIRECT('&B$2&'!A&MATCH($A5,INDIRECT('&B$2&'!A1:A541),0)&:A541),0)+MATCH($A5,INDIRECT('&B$2&'!A1:A541),0)-1))麻烦帮忙解释下 Match match ... EXCEL高手解释下下面这个公式什么意思.=INDIRECT($E$24&!l&MATCH(CONCATENATE($C$24,$E$24,$G$24,$C$21),INDIRECT($E$24&!F:F),0))举几个INDIRECT和MATCH组合运用的例子