Duplicate entries

dotswife

New Member
Joined
May 6, 2002
Messages
3
I need to merge 2 documents. When I do, there will be duplicate entries. What is the easiest and most accurate way to eliminate the duplicated entries?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
On 2002-05-07 11:58, dotswife wrote:
I need to merge 2 documents. When I do, there will be duplicate entries. What is the easiest and most accurate way to eliminate the duplicated entries?

If both worksheets has the same column headings/labels (fields in the database terminology), I'd import them from within Access into the same table, then export the table to Excel. All duplicate records will be eliminated as result.
 
Upvote 0
On 2002-05-07 11:58, dotswife wrote:
I need to merge 2 documents. When I do, there will be duplicate entries. What is the easiest and most accurate way to eliminate the duplicated entries?

Use Excel's Data | Get External Data | Create New Query... menu commmand to treat each Named Range as a separate table (e.g., Table1 and Table2) using the Excel ODBC driver and a SQL statement such as...

SELECT Table1.Field1
FROM Table1 Table1
UNION
SELECT Table2.Field1
FROM Table2 Table2
This message was edited by Mark W. on 2002-05-07 13:01
 
Upvote 0
On 2002-05-07 13:00, Mark W. wrote:
On 2002-05-07 11:58, dotswife wrote:
I need to merge 2 documents. When I do, there will be duplicate entries. What is the easiest and most accurate way to eliminate the duplicated entries?

Use Excel's Data | Get External Data | Create New Query... menu commmand to treat each Named Range as a separate table (e.g., Table1 and Table2) using the Excel ODBC driver and a SQL statement such as...

SELECT Table1.Field1
FROM Table1 Table1
UNION
SELECT Table2.Field1
FROM Table2 Table2
This message was edited by Mark W. on 2002-05-07 13:01

I suspected that much after that contrib of yours a few days ago. It's about time I install that driver :).

Aladin
This message was edited by Aladin Akyurek on 2002-05-07 13:06
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top