Get instant live expert help on How do I compare 2 columns in excel for matches

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

i need a fourmla to compare an name list in column A from sheet 1 with sheet 2 then compare id in column B from sheet 1 with sheet2 to find matches and no matches
Solved by M. S. in 21 mins
I have a problem regarding to How to Compare 2 Columns in Excel
Solved by A. A. in 23 mins
i need to compare 2 strings in 2 columns
Solved by F. D. in 17 mins
Hi how do you do a compare of the 2 columns in different spreadsheets and get a result of matches with yes or no. The spreadsheets are large and the column information varies
Solved by I. D. in 12 mins
Hi , I am trying to compare 2 if statements from 2 worksheets, if that matches then i need the count
Solved by B. Y. in 12 mins