How to Compare Data in Excel

Step-by-Step Guide

1. 1

   Step 1: Highlight the first cell of a blank column.

   When comparing two columns in a worksheet, you'll be outputting your results onto a blank column.
   
   Make sure you are starting on the same row as the two columns you're comparing.
   
   For example, if the two columns you want to compare start on A2 and B2, highlight C2.
2. 2

   Step 2: Type the comparison formula for the first row.

   Type the following formula, which will compare A2 and B2.
   
   Change the cell values if your columns start on different cells: =IF(A2=B2,"Match"
   
   "No match") , This will apply the formula to the rest of the cells in the column, automatically adjusting the values to match. , These will indicate whether the contents of the two cells had matching data.
   
   This will work for strings, dates, numbers, and times.
   
   Note that case is not taken into consideration ("RED" and "red" will match).
3. 3

   Step 3: Double-click the Fill box in the bottom corner of the cell.

4. 4

   Step 4: Look for Match and No match.

Detailed Guide

About the Author