$$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 __

$$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 [mailto:excel-mac...@googlegroups.co