How to compare two columns in different excel sheets?

Question

2 answer(s)

Answer # 2 #

You can also use Conditional Formatting → New Rule → Use formula to highlight differences across sheets.

Answered by: Guest Yrmdt [2 Month]

(3)

Answered by: Iftekhar Thevar · Accepted Answer

Answer # 1 #

Use formula: =IF(Sheet1!A1=Sheet2!A1,"Match","No Match"). Drag down to compare all rows.

Answered by: Iftekhar Thevar [3 Month]

(3)