I am trying to come up with a formula that puts an "OK" value in my Notes tab if the row has 2 or more consecutive 1 values. My rows have many more columns that just up to "N", this is just a screenshot I am using to try and make my question clearer.
I am admittedly a very novice excel user. Can anyone help me out here?
>Solution :
Thought I’d try a different approach.
TEXTJOIN("|",FALSE,$J2:$N2) will stick all the cells together separated by a pipe character.
If two cells contain a 1 you’ll get a 1|1 returned somewhere within the resulting text string, so you just need to find that.
=IF(ISNUMBER(FIND("1|1",TEXTJOIN("|",FALSE,$J2:$N2))),"OK","")