Have a look at these sites
http://www.mvps.org/dmcritchie/excel/duplicates.htm
http://www.cpearson.com/excel/duplicat.htm
best wishes
-
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"create_share" wrote in message
...
I have two excel sheets. In both sheets i have column A and B. In column A
i
have item code and in column B i have description. I need to find the
dissimilar items from these two sheets. I can't check one by one because
there are many items in both sheets.

Thankx!