consecutive

[CHollander]

Can I make a formula =if(4 consecutive cells contain "x", true, false)

[#2 · Accepted solution]

@CHollander 

=COUNT(SEARCH("X",A1:A4))=4

You can try this formula which is in cell B4 in the example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.

In german Excel the formula returns "WAHR" and "FALSCH" instead of "TRUE" and "FALSE".