How to remove all duplicates found in Sheet 1 and Sheet 2

Closed
-
Hello,

I have an excel sheet and I need some help in writing formula.

The excel has Sheet 1 with old data, Sheet 2 with new data and contains 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 results will be shown in Sheet 3.

I hope someone can help me writing the formula for my excel..Thanks in advance