Combine TWO Worksheets

  • Thread starter Thread starter Excel User
  • Start date Start date
E

Excel User

Greetings!

I have two "almost identical" worksheets and would like to combine them. How
can I do that without having duplicates in the final worksheet?

Greatly appreciated!
 
Copy all data into a single sheet, flag duplicates, apply a filter and
delete the flagged duplicates.

To flag duplicates, in a new column, enter a Countif() formula

Example, if the key field to find duplicates is column A, enter the
following formula in the first cell of the first vacant row (say, R1 if you
data goes to column Q)

=COUNTIF(A:A, A1)

Copy down so every row of your data contains the formula

Now click data, filter, autofilter

In the column with the countif apply the filter to select 'Custom'

Choose 'greater than' and enter 1

Your can now select all visible rows and press Edit. Delete
 
Back
Top