ExcelBanter - copmare cotents of two columns and return dissimilar values

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - copmare cotents of two columns and return dissimilar values (https://www.excelbanter.com/new-users-excel/41015-copmare-cotents-two-columns-return-dissimilar-values.html)

Shaukat Hussain

copmare cotents of two columns and return dissimilar values

Hi All,

I want to compare the contents of column A with Coulmn B and to get
dissimilar values.
I will be thankful for your kind information.

Gary's Student

In cell C1 enter
=if(A1=B1,"","dissimilar")
and copy down
--
Gary's Student

"Shaukat Hussain" wrote:

Hi All,

I want to compare the contents of column A with Coulmn B and to get
dissimilar values.
I will be thankful for your kind information.

All times are GMT +1. The time now is 12:57 PM.