need help

[Ladystark]

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 this..Thanks in advance

 

[rahulshewale1]

hii @Ladystark ,

Please find the attaced solution using Power Quey.

Sheet 1 Data
1.Convert Your data into Table (Short key is Ctrl+T)
2.Go to Power Query Tab
3. Select Close and Load only Connection.


Sheet 2 Data
1.Convert Your data into Table (Short key is Ctrl+T)
2.Go to Power Query Tab
3. Select Close and Load only Connection.

Then Go to Append Option
1.Primary table Select Table 1
2.Table to Append to primary table select table 2
3. power Query Window will open.
4.Go to Home tab in power Query >>Keep rows >>Select keep Duplicate option
5. Go to Home tab in power Query >>Remove Rows >>Remove Duplicate
6.Click on Close and load (1 st option )


Regard
Rahul shewale.