1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/Rodeohead12
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#AI formula generation techniques
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#wildcard
#COUNTIFS
#partial matches
#exact matches
#formula
#CONFLICT
#detect
#recognise
#range
#input
#column
#match
#space
#iteration