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...
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/