Home » Posts

Multiple columns are equal

To test if values in multiple columns are the same, you can use a simple array formula based on the AND function. In the example shown, the formula in H5 is: {=AND(B5=C5:F5)} Note: this is an array formula and must be entered with control + shift + enter, unless you are using Excel 365, where array formulas are native.

April 14, 2025 · 1 min · 49 words · Stephanie Smith

A count of zero returns TRUE, and any other number returns FALSE.

This isnotan array formula, so it does not require special handling.

AND returns TRUEonly if all the conditions are met.

Excel formula: Multiple cells have same value