excel多条件最大值的客户麻烦大神帮我看下谢谢

更新时间2018-10-01 18:46:05

=INDIRECT("B"&SUMPRODUCT(ROW($B$2:$B$13)*($A$2:$A$13=E3)*($C$2:$C$13=LARGE($C$2:$C$13*($A$2:$A$13=E3),1))))

相关标签:谢谢，大神，excel