Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Duplicate entries

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,658
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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.


  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,658
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •