$$Excel-Macros$$ compare two list

Hi Dilip , I want to compare two range ,-for finding the common uncommon (nos or text in it) presently I am using conditional formatting using countif fn Pls tell me how I check it through other methods Regards Manoj From: excel-macros@googlegroups.com

$$Excel-Macros$$ compare two list

Hi All , similar Items are @ different rows just like in attached file I want to compare two range ,-for finding the common uncommon (nos or text in it) presently I am using conditional formatting using countif fn Pls tell me how I check it through other methods Regards Manoj