ExcelBanter - Compare two columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Compare two columns (https://www.excelbanter.com/excel-worksheet-functions/200993-compare-two-columns.html)

Jeanne T

Compare two columns

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

Compare two columns

Hi

Put this in column C and drag down

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

Mike

"Jeanne T" wrote:

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.

Jeanne T

Compare two columns

Worked. Thank you!

"Jeanne T" wrote:

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.

All times are GMT +1. The time now is 01:33 AM.