mdmb
Reputation: 5283
Check if each cell range in a row contains the same value
How can I check in Google Sheets if each cell in a range e.g. B2:G2 contains a word e.g. holiday?
Upvotes: 0
Views: 84
Answers (1)
player0
Reputation: 1
=ARRAYFORMULA(IF(IFERROR(REGEXEXTRACT(B2:G2, "holiday"))<>"", TRUE))
=ARRAYFORMULA(IF(SUM(IF(IFERROR(REGEXEXTRACT(B3:G3, "holiday"))<>"", 1))=6, TRUE))
Upvotes: 1
Related Questions
- How to check if subsequent non-empty cells contains the same value?
- Check if multiple cell ranges are equal
- Check that all values in a range are identical
- Determining If the Cell Contents are Equal in Excel
- Finding if a value is located in a range of cells in a corresponding column, to a row with the same value as a given cell in a given row
- IF statement to show if ALL cells in a row have the same value
- How to check that all non-blank cells in range have same value?
- Excel formula to check if a range of data are all exactly same
- Excel Function (or VBA) to check the same value in cells
- Excel check if any 2 values within the same row equal any others