ExcelBanter - compare and take out duplicate data

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

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

- - compare and take out duplicate data (https://www.excelbanter.com/excel-worksheet-functions/114461-compare-take-out-duplicate-data.html)

cole trickle

compare and take out duplicate data

Hi I have two spreadsheets with name telephone address etc. I need to find
the dulicate data marked where ever it is existing

All times are GMT +1. The time now is 08:27 PM.