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.