3 Ways to Compare Columns in Excel for Matches

Maria is a Content Writer with a keen interest in Technology and Productivity Tools. Her articles can be found on sites such as Onlinetivity and Delesign. Outside of work, you can find her mini-blogging about her life on social media.

Ashish, Computer Engineer by profession, has been writing about tech for 16 years, with a primary focus on Windows and Smartphones. He has a keen interest in writing about social media, as it constantly evolves, introducing new features to explore.

Method 1. How to Compare Columns in Excel for Matches Using the EQUAL TO Operator

This is a simple way to confirm if columns within your Excel worksheet contain the same data. However, this method is not case-sensitive and only focuses on whether the text or number within the cells is the same.

Step 1:Ensure there is a dedicated column to display the result. In this case, we use theMatch Resultcolumn to compare Columns 1 and 2.

Step 2:Place yourcursorwithin a cell beside the cell you want to compare.

Step 3:Type=and select the first cellyou want to compare. It would be best if you had something similar to the text below:

Step 4:Type=again and select the second cell you would like to compare. It would be best if you had something similar to the text below:

Step 5:Tap theEnterkey on your keyboard for Excel to return aTRUE or FALSEvalue.

Step 6:Place yourcursorat the bottom right corner of the cell anddrag the formuladown to compare matches for other cells.

Method 2. How to Compare Columns in Excel for Matches Using the EXACT Function

Like most other functions in Microsoft Excel, the EXACT function is a pre-defined formula. The EXACT function checks whether two text strings are identical by returning a TRUE or FALSE value.

An important thing to note is that the EXACT function is case-sensitive. So, when you use different cases, it will return a FALSE value.

Step 1:Place yourcursorwithin a cell beside the columns you want to compare.

Step 2:Type=EXACT(into the cell and press theTabkey.

Step 3:Select thecellsyou want to compare and tap theEnterkey for Excel to return aTRUE or FALSEvalue. You should have something similar to the text below:

Step 4:Place yourcursorat the bottom right corner of the cell anddrag the formuladown to compare matches for other cells.

Method 3. How to Compare Columns in Excel for Matches Using the IF Condition

Another function you can use to compare column matches in Excel is the IF Function. With the IF Function, you can create conditions for the data in your worksheet. If the data in the columns meet or do not meet the conditions, set it up to return a particular result.

Step 1:Place yourcursorwithin a cell beside the columns you want to compare.

Step 2:Type=IF(into the cell and press theTabkey.

Step 3:Select the firstcellyou would like to compare. You should have something similar to the text below:

Step 4:Type=after selecting the first cell, select the second cell for comparison. You should have something similar to the text below:

Step 5:Enter the results you want Excel to return if the selected cells match. This is called the value if true and the value if false. You should have something similar to the text below:

Step 6:Press theEnterkey on your keyboard for Excel to return aTRUE or FALSEvalue.

Step 7:Place yourcursorat the bottom right corner of the cell anddrag the formuladown to compare matches for other cells.

Was this helpful?

Last updated on 11 July, 2024

Leave a ReplyCancel reply

Your email address will not be published.Required fields are marked*

Name*

Email*

Comment*

Δ

The article above may contain affiliate links which help support Guiding Tech. The content remains unbiased and authentic and will never affect our editorial integrity.

More in Windows

10 Ways to Fix Discord “RTC Connecting” and “No Route” Errors on Windows

6 Ways to Fix Media Player Not Working in Windows 11

JOIN THE NEWSLETTER

Get Guiding Tech articles delivered to your inbox.

© 2024 Guiding Tech Media. All Rights Reserved.