Excel Duplicates

Hi All,

I have company name in Column A and their respective address in Column B. I want to check, how many companies / what are the companies that share same address.

For example: Microsoft and Yahoo have same address as 1 Microsoft Way.

Regards,

Nirmal