Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 99
  • Last Modified:

Compare Columns Excel

Hello,
      I have 2 columns, (A&B)of data that I would like to compare and find matches. If there are matches I would like the matched cells to populate column C. Is there a simple way to do this? I have attached a file with some of the data as an example.

Thank you
Book1.xlsx
0
daskas27
Asked:
daskas27
  • 3
1 Solution
 
HakumCommented:
Away to do it might be using conditional formatting ->  highlight cell rules -> dulpicates, and then filter the color out.
0
 
ProfessorJimJamCommented:
put this in column C =IFERROR(INDEX(A:A,MATCH(B2,A:A,0)),"No Match")
0
 
ProfessorJimJamCommented:
alternatively you can do this also


=IF(ISNA(MATCH(A1,B:B,0)),A1,"No Match")   put in column C  
=IF(ISNA(MATCH(B1,A:A,0)),B1,"No match")    put in column D
0
 
daskas27Author Commented:
It tells me there is an error
0
 
ProfessorJimJamCommented:
there is no error. please see formula embedded in attached file.
Book1.xlsx
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now