copmare cotents of two columns and return dissimilar values

Shaukat Hussain · Aug 18, 2005

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 · Aug 18, 2005

In cell C1 enter
=if(A1=B1,"","dissimilar")
and copy down