Forum Discussion
Solved
Merging two sheets to find unique data
Hi! I have 2 excel sheets with data. The first excel sheet contains emails and usernames. The second sheet only contains usernames. The sequence of the usernames are different in both sheets. I w...
Paste the names from the second sheet below the names on the first sheet.
Click anywhere in the data.
On the Data tab of the ribbon, click Remove Duplicates.
Select only the name column.
Click OK. Excel will keep the names and email addresses from the first sheet in the same order.
Paste the names from the second sheet below the names on the first sheet.
Click anywhere in the data.
On the Data tab of the ribbon, click Remove Duplicates.
Select only the name column.
Click OK. Excel will keep the names and email addresses from the first sheet in the same order.
HansVogelaar Thank you so much!