compare two columns in excel and highlight same values

COMPARE TWO COLUMNS IN EXCEL AND HIGHLIGHT SAME VALUES HOW TO
COMPARE TWO COLUMNS IN EXCEL AND HIGHLIGHT SAME VALUES PLUS
COMPARE TWO COLUMNS IN EXCEL AND HIGHLIGHT SAME VALUES DOWNLOAD

Step 4: Apply the above formula to all we can drag down on clicking the Plus sign of the E2 cell in the Excel sheet. Step 3: Now click on the Enter button, the result will be shown based on the input data. Step 2: Click on the E2 cell, apply the EXACT function, select the B2 cell, apply the EXACT function, and select D2. Step 1: Go to Sheet 2 in the excel sheet where a user wants to be compared the data the user wants to check Home city and Preferred city, so apply the formula in the E column to compare.

COMPARE TWO COLUMNS IN EXCEL AND HIGHLIGHT SAME VALUES HOW TO

How to Compare the column data in Excel, which the user wants to match with the case of text? If we see the 5 th Row where B2 have Goa and D2 have GOA, their case is different in both the cells, but the equal function will not consider the case as it’s a case insensitive, so the result will be TRUE. Similarly, in B4 and D4, we have Delhi, which matches, so the result is TRUE. Summary of Example #1: As we can see in the result of example 1, there is B2 in Melbourne, and D2 is Delhi which is not matching, so the result is FALSE. Step 5: Apply the above formula to all we can drag down on clicking the Plus sign of the E2 cell. Step 3: Click on the E2 column and apply equal sign (=), Select B2 cell and put an equal sign, and select D2 Step 2: The user wants to check Home City and Preferred City, so apply the formula in the E column to compare in Excel

Step 1: Go to Sheet 1 in the Excel sheet, which a user wants to compare.

COMPARE TWO COLUMNS IN EXCEL AND HIGHLIGHT SAME VALUES DOWNLOAD

If you’re still having issues, head over to our Excel Guides.You can download this Text Compare Excel Template here – Text Compare Excel Template Compare Text in Excel – Example#1Ĭomparing for the two City in the employee table in Excel without caring about the case of text, two texts are Home city and Preferred City. There are so many use cases for Excel that it can get tricky. Hopefully, this helped you compare the data between two different columns in Microsoft Excel. If TRUE, it means your data matches if FALSE, it doesn’t. You should now have a new column with TRUE and FALSE statements. Copy the formula to the rest of the column by clicking and dragging down on the bottom right of the C2 cell.This gives you a TRUE or FALSE statement on whether your column’s data matches.If you want to compare more than these rows, select the rows you want to compare.Click cell C2 or whatever blank cell is adjacent to your last column.This technique is a straightforward way to run a quick match on column cells in Excel to get a TRUE or FALSE value on whether your column data matches. Compare Two Columns in Excel Using an Equals Formula Re-visit your conditional formatting rules later by selecting Conditional Formatting>Manage Rules. If you instead want to find Unique values, all you have to do is select Unique in the dropdown bar. Comparing Two Columns in Excel for Unique Entries Select the color you want to use for your highlight.Īnd that’s it! You’ve now selected all duplicate items in your spreadsheet.In the Home tab, click Conditional Formatting.Highlight the columns you want to compare.Follow these steps to highlight duplicate data in two columns. We’ll want to use Conditional Formatting and the Highlight tools to determine where our duplicate data is.

Comparing Two Columns in Excel for Duplicate Entries Are you trying to find duplicate entries in each column? Are you looking for mismatched data in the columns? Your goals will affect what steps you choose.īefore we get started, make sure to backup your file before we begin so that way, if you make a mistake, you’ll always have the raw data. What you’ll do depends on the goal of what you’re trying to accomplish with the data. 1.3 Compare Two Columns in Excel Using an Equals Formula How to Compare Two Columns In Excel

Compare two columns in excel and highlight same values