These formulas should do what you want...
1) =IF(COUNTIF(A2,"*J*K*"),1,IF(COUNTIF(A2,"*K*J*"),2 ,""))
2) =IF(COUNTIF(A2,"*J*L*"),IF(COUNTIF(A2,"*K*"),"",1) ,"")
3) =IF(COUNTIF(A2,"*J*K*L*"),1,"")
4) =IF(COUNTIF(A2,"*J*"),IF(OR(COUNTIF(A2,"*K*"),COUN TIF(A2,"*L*")),"",1),"")




Reply With Quote
Bookmarks