excel找最小值对应的名称答:=OFFSET($A$1,,MATCH(MIN($A$2:$E$2),$A$2:$E$2,0)-1)显示最小的甲 2 空白单元格输入 =IF(ISERROR(INDEX($A$1:$F$1,,SMALL(IF($A$2:$E$2=MIN($A$2:$E$2),COLUMN($A$1:$E$1),888),COLUMN(A1))),"",INDEX($A$1:$F$1,,SMALL(IF($A$2:$E$2=MIN($A$...
EXCEL中用函数查找显示同时满足多个条件的最小值和对应数据行的字段内...答:H2 =MINIFS(E:E,C:C,"总分",A:A,G2)I2 =INDEX(B:B,MATCH(H2,E:E,0))J2 =MINIFS(E:E,C:C,"语文",A:A,G2)K2 =INDEX(B:B,MATCH(J2,E:E,0))公式可以一并下拉
如图,excel中如何求I1的值?是个最小值对应单元格文本的组合,用“,”间...答:见截图 I2输入 =IF(C1=H1,B1&",","")&IF(E1=H1,IF(G1=H1,D1&",",D1),"")&IF(G1=H1,F1,"")公式下拉