Remove duplicates in 2 sheets ans unique values will be shown in sheet 3

Question

Hello ,I hope everyone is doing well today. I badly need your help and I really don't know what to do.&nbsp;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.&nbsp;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.&nbsp;I hope someone can help me on this, been trying to search all day to find an answer..Thanks in advance

sergeibaklan · Answer

Hi,&nbsp;If your data is changed frequently better to do that with Power Query (Get &amp; Transform in 2016).&nbsp;If more or less static you may copy/paste everything in Sheet3 and after that use Data-&gt;Remove duplicates. See for example here&nbsp;https://www.howtogeek.com/198052/how-to-remove-duplicate-rows-in-excel/&nbsp;

Forum Discussion

Remove duplicates in 2 sheets ans unique values will be shown in sheet 3

Share

Resources