Co-Authored By:

##### Asked by: Rahul Mazurkiewic

science genetics# How do I compare cell values from one column to another in Excel?

**How to compare two columns to find duplicatesinExcel**

- Highlight
**column**A by clicking the**column**header. - Select the Conditional Formatting button under theHometab.
- Select New Rule from the Conditional Formattingdrop-downlist.
- Select the 'Use a formula to determine which
**cells**toformat' option. - Enter the formula provided in the text box.
- Click on the Format button.

Just so, how do I check if a value in one column exists in another column in Excel?

Select a blank cell next to the data you want to sum,andenter this formula =**IF**(ISERROR(VLOOKUP(C2,$A$2:$A$7,1,FALSE)),FALSE,TRUE ), then drag autofill handle down to applythisformula to the **cells**, **if** it displays TRUE, thenthecorresponding data **exists in another column**, and**if**it shows FALSE, the corresponding

**For example, if you want to compare A2 withB2,use:**

- =EXACT(A2,B2) If the two strings are identical, EXACTwillreturn TRUE.
- =IF(EXACT(A2,B2),"Yes","No") Note the EXACT function iscasesensitive.
- =A2=B2. This formula will return TRUE or FALSE, and willtreat"Apple" and "apple" as the same.

Consequently, how do I compare two cells in Excel to return true or false?

The following formula can help you quickly**comparetwo** adjacent **cells** and **return** Yes ifthey arematched in **Excel**. Please do as follows. 1. Select ablank**cell**, copy formula =IF(A2=B2,"Yes","") into the formulabarand then press the Enter key.

**Compare Two Columns and Highlight Matches**

- Select the entire data set.
- Click the Home tab.
- In the Styles group, click on the 'ConditionalFormatting'option.
- Hover the cursor on the Highlight Cell Rules option.
- Click on Duplicate Values.
- In the Duplicate Values dialog box, make sure 'Duplicate'isselected.