Forum Discussion

CHollander's avatar
CHollander
Copper Contributor
Dec 07, 2022
Solved

consecutive

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

  • 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". 

1 Reply

  • 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". 

Resources