Hi
@meghanirale ,
In Excel 1, create a new column and insert the formula to concatenate both the column data i.e. name and number using CONCATENATE function of Excel. Similarly, perform the same action in Excel 2 as well. Now perform a vlookup on Excel 2 to search for the records in Excel 1. The records which are not found using vlookup (the values which give #NA as the result) are the unique ones and the ones which are matched are the duplicate ones.
Please let me know if the solution worked for you.