I have a spreadsheet in Excel that contains company names and addresses. I need to find the companies that have the same address. I will also need to delete the company names if they are duplicated. Please help me with VB or please give some direction. I greatly appreciate anyones help. Thank you.