ExcelBanter - How do i compare and remove common names from 2 excel work sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do i compare and remove common names from 2 excel work sheets (https://www.excelbanter.com/excel-worksheet-functions/260969-how-do-i-compare-remove-common-names-2-excel-work-sheets.html)

Andrew

How do i compare and remove common names from 2 excel work sheets

Task is to compare 2 excel worksheets containing humngus list of companies
names' (approx word match only in each sheets); sort out and remove the
common names from one work sheet. How would i get this done with the least
effort possible? Kindly help!

All times are GMT +1. The time now is 11:08 AM.