...查找对应B列中相同名称时对应C列的最大值。并将最大值对应行数据在...答:E3输入IFNA(INDEX(B:B,MATCH(,COUNTIFS($E$1:$E2,$B$3:$B$5000,$F$1:$F2,$C$3:$C$5000),)+2),"")后,CRTL+SHIFT+回车,然后右拉到F列,然后下拉填充到F5 G3输入MAX(D3:D5000,INDEX(D3:D5000,MATCH(F3,C3:C5000,0)))后,CRTL+SHIFT+回车,然后下拉到G5 ...
excel找出列相同的最大值分别乘不同系数!答:=IF(COUNTIF(B:B,B1)=1,MAX(IF($B$1:$B$4=B1,$A$1:$A$4,""))*1.5,IF(COUNTIF($B$1:B1,B1)=1,MAX(IF($B$1:$B$4=B1,$A$1:$A$4,""))*1.73,0))同时按CTRL SHIFT 回车键 ,再下拉 照此操作 根据实际修改区域 ...
...找出名字及对应的最大值,在根据值进行分等级答:假设左表数据在A:F列,右表在J:M列,则:K2=COUNTIF(F:F,"<300")K3=COUNTIF(F:F,"<600")-COUNTIF(F:F,"<300")K4=COUNTIF(F:F,"<900")-COUNTIF(F:F,"<600")K5=COUNTIF(F:F,">=900") L2=SUMIF(F:F,"<300")L3=SUMIF(F:F,"<600")-SUMIF(F:F,"<300")L4=...