excel高手进，怎么利用公式直接得出最低价和最低价地区，

显示全部楼层 · 2012-10-9 20:30:24

为啥非要高手解答呢？将设对应列次：名称A、上海B、贵州C、……广东H、最低价地区I、最低价J以三行（雪犁）为例，先在“J列”，最低价J=MIN(B3:H3)然后再最低价地区I=IF(ISERROR(FIND(J3,B3,1)),"",IF(OR(J3=C3,J3=D3,J3=E3,J3=F3,J3=G3,J3=H3),$B$2&"、",$B$2))&IF(ISERROR(FIND(J3,C3,1)),"",IF(OR(J3=D3,J3=E3,J3=F3,J3=G3,J3=H3),$C$2&"、",$C$2))&IF(ISERROR(FIND(J3,D3,1)),"",IF(OR(J3=E3,J3=F3,J3=G3,J3=H3),$D$2...

千问 · 2012-10-9 20:30:24

i3输入:=index($2:$2,match(min(b3:h3),b3:h3,)+1)j3输入:=min(b3:h3)选择i3:j3,下拉填充...