EXcel中,找出每行数据前5大数值所对应的内容?例如下图,第二行标黄色...答:A2=SUBSTITUTE(TEXT(MID(SUMPRODUCT(MOD(MOD(LARGE(IF($B2:$K2>=LARGE($B2:$K2,5),$B2:$K2*10^9+COLUMN($A$1:$J$1)*10^5+$B$1:$K$1,""),ROW($1:$5)),10^5),10)*10^-ROW($1:$5))&"0",3,5),"0!.0!.0!.0!.0"),"0","10"),按CTRL+SHIFT+ENTER结束公式...