Where to put the *wildcard*
I know this is starting to make my formula complicated, but hear me out. This is it in it's current iteration:
=IF(COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2,$C$2:$C10,C2)>1,"CONFLICT"," ")
So far, this means if anything in the range of A2-A10 matches A2, B2-B10 matches B2 AND C2-C10 matches C2 exactly, without counting Row 2, return CONFLICT if true and a space if false.
I want it to be able to recognise partial matches in columns rather than exact matches. I feel like this should be possible with wildcards, but I don't know where it should go, or how to input it. I also can't specify what it should search, just to detect if there's a partial match between rown.
Eg, A2 is 1, B2 is Z, C2 is A; B; C A2 is 1, B2 is Z, C7 is B
The formula as it is doesn't view this as true because it's not an exact match. I want it to return true due to the partial 'B' match.
Is this possible? Am I thinking about it the wrong way?
[link] [comments]
Want to read more?
Check out the full article on the original site