Excel 筛选、包含问题。求高手指教答:=IF((IFERROR(FIND(A1 & “,",D1& “,"),0))+(IFERROR(FIND(B1 ",",D1& “,"),0))+(IFERROR(FIND(C1& “,",D1& “,"),0)),1,0)
Excel问题,请您帮忙,谢谢答:这个纯公式比较麻烦,将源数据放在E3开始,周围全填上0.1,然后在X3单元格录入公式:=IF(E3<>"",IF(IF(OR(IFERROR(AND(F4=E3+1,G5=F4+1),0),IFERROR(AND(E3=D2+1,F4=E3+1),0),IFERROR(AND(D2=C1+1,E3=D2+1),)),1,"")=1,E3,""),"") 然后填充公式至源数据形状. ok...