• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Comapring values in the columns

jaku123

New Member
I like to compare two columns and need to write the output 1 or 0 (if the both are same 0,different 0).


Example:Let us say i have column A with some Name(alphanumeric) and column B with some Name (alphanumeric).The name in the A and B might be same or different.The same Name in Column A will in Column B in the different CellB.I like to compare both of them and pick out by assing the values 1 or 0.Pl let the solution.Thanks in Advance.
 
You can do 1 of several things


Compare cell by cell in C2: =if(A2=B2,"Match","")

copy down to check other cells


Compare the whole column in C2: =IF(A:A=B:B,"Match","")


or


have a read of lots of other ideas at http://chandoo.org/wp/2010/06/17/compare-2-lists-in-excel/
 
Back
Top