excel 复合运算 a*b+c*d+e*f...一直加下去答:=IF(AND(D1="",E1="",F1="",G1=""),"",IF(OR(D1<TODAY(),E1<TODAY(),F1<TODAY(),G1<TODAY()),"EXPRIRY",""))下拉或复制公式,如果是从第二行开始,将E1,D1,F1,G1换成D2,E2,F2,G2
excel复合统计公式问题答:结果略有不同,G列列出所有的顺序,D列需要增加辅助。G2公式{=INDEX($D$2:$D$6,MATCH(LARGE(COUNTIFS(A:A,$F$2,B:B,$D$2:$D$6)+ROW()*0.00001,ROW()-1),COUNTIFS(A:A,$F$2,B:B,$D$2:$D$6)+ROW()*0.00001,0))} 选中G2:G6,一起按ctrl+shift+enter。H2=COUNTIFS...