And if you want to know all the values that are different, filter all the values that are FALSE (as shown below): Now, if you need to know all the values that match, simply apply a filter and only show all the TRUE values. The above formula will give you a TRUE if both the values are the same and FALSE in case they are not. Suppose you have the below dataset and you want to know what rows have the matching data and what rows have different data.Д«elow is a simple formula to compare two columns (side by side): =A2=B2 Compare Side by Side Using the Equal to Sign Operator So let me show you a couple of easy ways to do this. And remember, there is always a chance of human error when you do this manually. Of course, you can do this when you have a small dataset when you have a large one, you can use a simple comparison formula to get this done. Suppose you have a dataset as shown below and you simply want to check whether the value in column A in a specific cell is the same (or different) when compared with the value in the adjacent cell. This is the most basic type of comparison where you need to compare a cell in one column with the cell in the same row in another column. Common Queries when Comparing Two Columns.Compare Two Columns Using VLOOKUP and Find Differences (Missing Data Points).Compare Two Columns Using VLOOKUP and Find Matches.Compare Two Columns Using VLOOKUP (Find Matching/Different Data).Highlight Rows with Matching Data (or Different Data).

Compare Side by Side Using the IF Function.

Compare Side by Side Using the Equal to Sign Operator.

Compare 2 columns excel find duplicates