How do I compare two columns and highlight when they are in another column?
Compare two columns and highlight matches
- Select the entire data set.
- Click on the Home tab.
- In the Styles group, click the ‘Conditional Formatting’ option.
- Hover over the Highlight Cell Rules option.
- Click Duplicate Values.
- In the Duplicate Values dialog, make sure ‘Duplicate’ is selected.
Table of Contents
How do you check if a column is present in another column in Excel?
Example using VLOOKUP
- Select cell C2 by clicking on it.
- Insert the formula into “=IF(ISERR(VLOOKUP(A2,$B$2:$B$1001,1,FALSE)),FALSE,TRUE)” in the formula bar.
- Press Enter to assign the formula to C2.
- Drag the formula down to the other cells in column C by clicking and dragging the small “+” icon at the bottom right of C2.
How do you find duplicates in multiple Excel columns?
Find and highlight duplicates in multiple columns in Excel
- Select the data.
- Go to Home -> Conditional Formatting -> Highlight Cell Rules -> Duplicate Values.
- In the Duplicate Values dialog box, select Duplicate from the drop-down menu on the left and specify the format in which you want to highlight duplicate values.
How do you find matching values in two columns in Google Sheets?
Below are the steps to search columns for matching data:
- Select the top cell in the comparison column (yellow arrow).
- Enter the formula =VLOOKUP(Compare Cell, Compare Column Range, Recall Value, Exact or Approximate Compare) (blue arrow).
How do I compare two columns in google sheets and highlight matches?
Conditional formatting to compare data in two Google Sheets
- Select the range with records to color (A2:A10 for me).
- Go to Format > Conditional Formatting in the spreadsheet menu.
- Enter a simple formula for the rule: =A2=C2.
- Choose the color to highlight the cells.
How do I compare two Google Columns in Excel?
How to compare two columns for exact row matches
- In the second row of column C (in cell C2), enter the formula: =A2=B2.
- Press the return key.
- Double-click the fill handle to copy the same formula to the rest of the cells in column C.