How do you merge two excel sheets and remove duplicates?
- 1 Answers
- 774 Views
- I also Faced
- E-Mail Answers
Answer / Prabhanjan Kumar
To merge two Excel sheets and remove duplicates, follow these steps: n
1. Merge the worksheets using 'Move or copy' (right-click on a sheet name and choose Move or Copy).
2. Sort the data if necessary.
3. Use Remove Duplicates from the Data tab.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do you mean by rows and columns?
Explain few useful functions in excel.
How do I update excel on my laptop?
Can you get excel free?
How do I unhide hidden sheets?
How do you use the value function in excel?
How do I count cells with text in excel?
Where is autosum in excel?
What is the purpose of excel?
How do I switch first and last name in excel?
In order to apply the same formatting to every sheet in a workbook in ms-excel what needs to be done?
How do you insert multiple rows?
MS Excel Microsoft 
