|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 sp_chee 于 2016-7-25 10:56 编辑
G3:=IF(SUM(IF((F3=$C$3:$C$15)*(E3=$B$3:$B$15)*($A$3:$A$15)>0,1,0))=2,LARGE((F3=$C$3:$C$15)*(E3=$B$3:$B15)*($A$3:$A$15),2),IF(SUM(IF((F3=$C$3:$C$15)*(E3=$B$3:$B$15)*($A$3:$A$15)>0,1,0))=1,MAX((F3=$C$3:$C$15)*(E3=$B$3:$B$15)*($A$3:$A$15)),""))
H3:=IF(MAX((F3=$C$3:$C$15)*(E3=$B$3:$B$15)*($A$3:$A$15))=0,"",IF(MAX((F3=$C$3:$C$15)*(E3=$B$3:$B$15)*($A$3:$A$15))=G3,"",MAX((F3=$C$3:$C$15)*(E3=$B$3:$B$15)*($A$3:$A$15))))
都是数组公式,往下复制 |
|