Compare Two Columns in Excel: Find Matches and Differences Row by Row
Want to compare two columns in Excel row by row and quickly find matching entries or differences?
In this video, I’ll show you three easy methods: using a shortcut, Kutools for Excel, and a formula.
● Method 1: Use a Shortcut （Ctrl + \）
● Method 2: Use Kutools for Excel
● Method 3: Use a Formula： =EXACT(A2,B2)
⭐Know more about Kutools for Excel:
https://go.extendoffice.com/compare-t...