Forum Discussion
CHollander
Dec 07, 2022Copper Contributor
consecutive
Can I make a formula =if(4 consecutive cells contain "x", true, false)
=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".
1 Reply
Sort By
- OliverScheurichGold Contributor
=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".