ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Comparing two worksheets with two columns each for duplicates (https://www.excelbanter.com/excel-discussion-misc-queries/71773-comparing-two-worksheets-two-columns-each-duplicates.html)

jlcnewyork

Comparing two worksheets with two columns each for duplicates
 
I have a list of plaintiffs with first and last names separated over two
columns in one worksheet. I want to compare the names to another list of
plaintiffs in a second worksheet to see if there are duplicates. Can anyone
help with this. I think it involves comparing the last names and then, if one
matches, comparing the first names. Thank you!


All times are GMT +1. The time now is 05:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com