excel找出特定行

显示全部楼层 · 2013-6-21 13:45:37

在F1中输入或复制粘贴下列公式之一=IF(COUNTIF(A1:E1,3)*COUNTIF(A1:E1,5)*COUNTIF(A1:E1,7),"是","")=IF(COUNTIF(A1:E1,3)*COUNTIF(A1:E1,5)*COUNTIF(A1:E1,7)=0,"","是")=IF(AND(COUNTIF(A1:E1,3)>0,COUNTIF(A1:E1,5)>0,COUNTIF(A1:E1,7)>0),"是","")=IF(COUNT(0/COUNTIF(A1:E1,{3,5,7}))=3,"是","")下拉填充...

千问 · 2013-6-21 13:45:37

F1输入=if(countif(A1:E1,3)*countif(A1:E1,5)*countif(A1:E1,7),"是","")下拖填充即可...

千问 · 2013-6-21 13:45:37

F1公式：=IF(COUNT(0/COUNTIF(A1:E1,{3,5,7}))=3,"是","")下拉即可。...

千问 · 2013-6-21 13:45:37

最粗糙的来一个，yes表示符合，no表示不符合，在f列标记f1=if(and(isnumber(match(3,a1:e1,0)),isnumber(match(5,a1:e1,0)),isnumber(match(7,a1:e1,0))),"yes","no")下拉简单一点的，数组公式，按ctrl+shift+enter三键=IF(IS...