Show Compare Two Columns in Excel (Table of Contents)
Compare Two Columns in ExcelComparing two columns in Excel is comparing the values in those columns. There are different ways to do this. In a first way, we can select the parallel cells of the columns, which we want to compare by separating them with an equal sign (“=”). This will give us the output as TRUE and FALSE. If a cell of the columns is matched, then we will get TRUE, else FALSE. In another way, we can use the IF function to match the column cells the way we do by putting an equal sign to get the message we want when columns are matched. How to Compare Two Column Data?There are a lot of ways to do that. They are:
Compare Two Column Data By Row-wise – Example #1When we are looking for an exact match, use this technique. Let’s take the below example to understand this process. We have given the below dataset where we need to analyze the sold product of two stores month-wise. This means, Is the same product purchased by the customer in the same month or not? If the same product is being sold month-wise, the result should return as ‘TRUE’ otherwise ‘FALSE’. For this, we will apply the below formula: =B4=C4 Refer to the below screenshot: The result is shown below: Drag & drop this formula for the rest values, and the result is shown below: Using Conditional Formatting – Example #2By using conditional formatting, we can highlight the data in cells. If the same data point exists in both the columns row-wise, then we want to highlight those cells. Let’s take an example for this. We have given year-wise performance data where we want to analyze if we have achieved the same performance in the same year. Follow the below steps:
The result is shown below: Highlight the matching data – Example #3Here we are comparing the data in the whole list column-wise. Let’s take the below example to understand this process.
Things to Remember about Compare Two Columns in Excel
Recommended ArticlesThis has been a guide to Compare Two Columns in Excel. Here we discuss Compare Two Columns in Excel and how to use the Compare Two Columns in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles – |