Compare two columns

[Jeanne T]

How can I compare two columns to find only those that are different?

Ex: Col A Col B Difference

EA EA None
EA EA None
EA PK Difference

Thank you for any responses and help on this.

 

[Mike H]

Hi

Put this in column C and drag down

=IF(A1=B1,"None","Difference")

Mike

 

[Jeanne T]

Worked. Thank you!