Need Help? Chat with us

# How to Compare Two Columns in Excel?

How to Compare two Columns in Excel Step-By-Step. Find difficulty in finding the same text in Excel, you can have a look for comparing two columns for matches or differences in the same row Like a two-dimensional database.

Excel is capable of storing many different types of data from small business contacts to personal income tax records. In both of these examples, accuracy is essential to make sure you have the information you need when you need it.

## How to Compare Two Columns in Excel?

There mainly two ways to compare Two Columns in Excel as follows,

1. Compare Two Columns for Matches or Differences in the Same Row
2. The Compare Two Lists for Case-Sensitive Matches in the Same Row

## Compare Two Columns for Matches or Differences in the Same Row

To compare two columns in excel you have to follow below step by step process,

### Step 1: Create a table similar to the above picture.

• This table is showing the employee list of two departments.
• We will find the match of employee name between these IT and Account departments.
• Column C will find the match between Column A and B in the same row.  ### Step 2: In cell C2 we will use this formula

=If(logical_test,”Value_if_True”,”Value_if_False”) In our case: logical_test: A2=B2, Because we want to find match if the values of cell A2 and B2 are same Value_if_True: Match, If found A2=B2 then the value of cell C2 will be “Match” Value_if_False: “”, If found “A2 is not equal to B2” then the value of cell C2 will be blank (“”) So, In cell C2 our formula will be: =IF(A2=B2,”Match”,””)  • 200+ Video Tutorials • 80 Case Studies • 3 eBooks • 2 Webinar • 24*7 Dedicated Support

### Step 3: Value is showing blank

Press ENTER. Now in cell C2 value is showing Blank (“”), because there are no match between cell value of A2 (John) and Cell value B2 (Johm).

###  Step 4: Copy Formula & Dragging the File Handle

Copy this formula from cell C2 down to other cells by dragging the fill handle (a small square in the bottom-right corner of the selected cell C2). As you do this, the cursor changes to the plus sign.

###  Step 5: Result of matching between Column A & B

After copy the formula to another cell of column C we will get the result of matching between to column A and B as like the above picture. As a result, we can see row 4 and row 7 has the same employee name in both departments. (i.e. how to compare two columns in excel) Tip 1: To find cells in the same row with different content, simply replace “=” with the non-equality sign: =IF(A2<>B2,”No match”,””) And do previous steps again. Then we will get a result as shown in the image.  ## Compare Two Lists for Case-Sensitive Matches in the Same Row

Now we will find an exact same name for case-sensitive matches. That is also called to compare two rows & columns in excel. To compare two columns in excel you have to follow below step by step process,

### Step 1: in Cell B7 Type ‘SHAHRIAR’ instead of ‘Shahriar’. Delete all formulas from Column C. ### Step 2: Now use this formula in cell C2: =IF(EXACT(A2, B2), “Match”, “”) Press ENTER and copy this formula to another cell of Column C.  