Table of Contents
Do you have four columns of data in Excel and need to compare them? Comparing four columns of data in Excel can be done quickly and easily with a few simple steps. In this article, we will show you how to compare four columns in Excel with an example. We’ll walk you through the steps to compare the data in the columns, highlight any differences, and make sure all the data is accurate. By the end of this article, you’ll know exactly how to compare four columns in Excel.
You can use the following basic formula to compare four columns in Excel:
=IF(AND(B2=C2,C2=D2,D2=E2),"Equal","Not Equal")
This particular formula compares the values in cells B2, C2, D2 and E2.
If all of the values are equal, the formula returns Equal. Otherwise, it returns Not Equal.
The following example shows how to use this formula in practice.
Example: Compare Four Columns in Excel
Suppose we have the following dataset that shows the highest scorer on various basketball teams during four different games:
We can type the following formula into cell F2 to test if the four values in the first row are all equal:
=IF(AND(B2=C2,C2=D2,D2=E2),"Equal","Not Equal")
The following screenshot shows how to use this formula in practice:
The formula returns Not Equal since the four names in the first row don’t all match.
We can then drag this formula in cell F2 down to the remaining cells in column F to test for matches in each row:
Notice that the formula only returns Equal for the rows where the cell values are equal across each of the four columns.
You can also apply conditional formatting to the rows where all three cell values are equal by highlighting the cell range F2:F11, then clicking on the Conditional Formatting button on the Home tab, then clicking Highlight Cell Rules, then clicking Equal To:
In the new window that appears, type Equal into the box and choose a fill color, then click OK:
The rows that have matching values across all four columns will now be filled with green:
