+ Reply to Thread
Results 1 to 2 of 2

how do i compare two columns and remove duplicates?

  1. #1
    aljernon805
    Guest

    how do i compare two columns and remove duplicates?

    i need to repeat a specific function almost daily. i have two coulums of 10
    digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i
    want to search a for the sets of numbers in b. when found i need to elimnate
    them from both colums.

    i am a beginner in excel. i believe a macro can do this but have no idea
    how to create one.



  2. #2
    gls858
    Guest

    Re: how do i compare two columns and remove duplicates?

    aljernon805 wrote:
    > i need to repeat a specific function almost daily. i have two coulums of 10
    > digit numbers. a is about 10 k to 60 k. b is usually less than 10 k. i
    > want to search a for the sets of numbers in b. when found i need to elimnate
    > them from both colums.
    >
    > i am a beginner in excel. i believe a macro can do this but have no idea
    > how to create one.
    >
    >

    Take a look at this excellent site provided by Pearson Software

    http://www.cpearson.com/excel/duplic...tingDuplicates

    gls858

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1