Multiple Cells Are Equal Excel Formula
Note: this is an array formula and must be entered with control + shift + enter. In this case the we simply compare one range with another with a single logical expression: The two ranges, B5:B12 and F5:H12 are the same dimensions, 5 rows x 3 columns, each containing 15 cells. The result of this operation is an array of 15 TRUE FALSE values of the same dimensions: {TRUE,TRUE,TRUE; TRUE,TRUE,TRUE; TRUE,TRUE,TRUE; TRUE,TRUE,TRUE; TRUE,TRUE,TRUE; TRUE,TRUE,TRUE; TRUE,TRUE,TRUE; TRUE,TRUE,TRUE} Each TRUE FALSE value is the result of comparing corresponding cells in the two arrays....