Report

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

Ask a question ladystark
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!