Forum Discussion
Remove duplicates in 2 sheets ans unique values will be shown in sheet 3
Hello ,
I hope everyone is doing well today. I badly need your help and I really don't know what to do.
The excel sheet I am working on right now has Sheet 1 with old data in column O to T, Then, Sheet 2 column A to F contains new data and some old data that can be found from Sheet 1.
What I want to happen is, it will remove all duplicates found in Sheet 1 and Sheet 2 and the Unique values will be shown in Sheet 3.
I hope someone can help me on this, been trying to search all day to find an answer..Thanks in advance
1 Reply
Hi,
If your data is changed frequently better to do that with Power Query (Get & Transform in 2016).
If more or less static you may copy/paste everything in Sheet3 and after that use Data->Remove duplicates. See for example here https://www.howtogeek.com/198052/how-to-remove-duplicate-rows-in-excel/
