ExcelBanter - Compare two variables across two worksheets

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

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

- - Compare two variables across two worksheets (https://www.excelbanter.com/excel-worksheet-functions/71651-compare-two-variables-across-two-worksheets.html)

jlcnewyork

Compare two variables across two worksheets

How do I compare one worksheet with first and last names in separate columns
with another worksheet with a list of first and last names in separate
columns? I need to find the duplicates and list those in a third worksheet.
Thank you!

All times are GMT +1. The time now is 11:53 PM.