lundi 29 mai 2017

IF Statement with wildcards and text and NOT logic

I am trying to create an array formula that will exclude any values that contain PTIC or Station Mated. Within the data there are various permutations of PTIC and station mated e.g. PTIC heifers, PTIC heifer, PTIC cows etc.

If I write the formula without wild cards and type in all the possible permutations of PTIC and station mated, the formula has worked. However, I want to make it more robust, in case new permutations appear in the future. I've tried this but it hasn't excluded them:

={IF(OR(Results!$K:$K<>"PTIC",Results!$K:$K<>"Station Mated"),1,0)}

Any ideas? Thanks!

Aucun commentaire:

Enregistrer un commentaire