common entries between 2 columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two lists of numbers or names and I want to find the ones that are
common between the 2. The lists are say column A and column B in excel.
 
Andreas,

In cell C1, use the formula

=IF(ISERROR(MATCH(B1,A:A,FALSE)),"","Also in column A")

And copy down to match your list in column B.

You can write a similar formula to highlight the values in column A.

HTH,
Bernie
MS Excel MVP
 
Hi,

Try this. Assuming you have one list in range A1:A5 and the other one in
range B1:B5, enter hter following array formula (Strl+Shift+Enter) in cell C1

=OR(EXACT(A1,$B$1:B5))

Regards,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding up total hours worked on employee schedule using various criteria 0
Multiple List Analysis 0
Copy corresponding cell in Column B if cell in A contains certain text? 1
Determine if 2 cells share a common word 2
Compare two sheets and combine into one 2
comparing data in excel 3
Excel Concatenate with line breaks but ignore blank cells 3
Copying formulas across columns 2

Back
Top