sampsonpon 发表于 2015-5-24 10:29
sorry!昨晚忘了插入附件了。现传附件。谢谢!
E9输入 去重复公式
=IF(ROW(1:1)>ROUND(SUM(1/COUNTIF($A$2:$A$5596,$A$2:$A$5596)),0),"",INDEX($A$2:$A$5596,SMALL(IF(MATCH($A$2:$A$5596,$A$2:$A$5596,0)=ROW($A$2:$A$5596)-1,ROW($A$2:$A$5596)-1),ROW(1:1))))
数组公式,按CTRL+SHIFT+ENTER结束
下拉填充
F9输入 提取对应的最小值
=MIN(IF(A2:A5596=E9,B2:B5596))
数组公式,按CTRL+SHIFT+ENTER结束
下拉填充 |