Logical
Check if multiple cells are all equal (unanimous approval check)
Verify every cell across a row holds the same non-blank value with COUNTIF and COUNTA, or enforce exact casing with EXACT.
Scale beyond A2=B2 across 4, 10, or 50 columns
Chained A2=B2=C2=D2 expressions compare intermediate booleans rather than testing all four values for equality. Test every cell against A2 and separately require no blanks.
SUMPRODUCT equality is case-insensitive and treats wildcard characters literally. Use EXACT for case-sensitive text.
| Rev1 (A) | Rev2 (B) | Rev3 (C) | Rev4 (D) | Case-Insensitive / Exact |
|---|---|---|---|---|
| Approved | Approved | Approved | Approved | TRUE / TRUE |
| Approved | Approved | Approved | approved | TRUE / FALSE |
| Approved | Approved | Approved | (blank) | FALSE / FALSE |
Blank-safe unanimous equality formula
COUNTBLANK excludes both genuinely empty cells and formulas returning an empty string.
=AND(COUNTBLANK(A2:D2)=0, SUMPRODUCT(--(A2:D2=A2))=COLUMNS(A2:D2))Case-sensitive unanimous check with EXACT
AND(COUNTBLANK(A2:D2)=0, EXACT(A2, B2), EXACT(A2, C2), EXACT(A2, D2)) requires identical letter casing.
=AND(COUNTBLANK(A2:D2)=0, EXACT(A2, B2), EXACT(A2, C2), EXACT(A2, D2))Try the example
Use the original values or change them to test your understanding.