EXCEL 自动选取前列中大于0.2的所有数字答:你的描述和表的数值有矛盾 详见截图 B2输入 =IF(COLUMN()=2,INDEX($A:$A,MIN(IF(($A$2:$A$10>=0.2)*(COUNTIF(B$1:B1,$A$2:$A$10)=0),ROW($2:$10),100))),INDEX($A:$A,MIN(IF(($A$2:$A$10<0.2)*(COUNTIF(B$1:B1,$A$2:$A$10)=0),ROW($2:$10),100)...
excel前列输入数字,后列显示不及格及格一般良好优秀?答:C2=lookup(b2,{0,60,70,80,90},{"不及格","及格","一般","良好","优秀"})