#1
  1. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    May 2013
    Location
    Aarhus, Denmark
    Posts
    50
    Rep Power
    5

    An old question with a twist...


    Hi everyone

    This is kind of an old and often asked question but I have a twist to it so I am going to ask it again

    Duplicate values. I want to find all the unique values and copy them leaving duplicates behind.
    The twist: I do not want the duplicates at all. Not the double value and not the original value for the double.
    A little confused?
    Here is an example, then I going to explain my actual problem.

    Sheet1 ---- Sheet2 ----- What I want
    fox --------------- fox --------------- cat
    cat -------------- rabbit
    rabbit -------------bird
    bird


    I have a sheet in excel with lots of data.
    The data is animal speciments from a natural history museums collection.

    Now the problem is, that someone has made a copy of the original file changes a lot of names to the correct ones, and saves this new file.
    So long so good. No one is in trouble yet
    But somehow the new file is missing 35.466 rows of data. This is a problem.
    The original file is 90.000'ish records long, so no one really want to begin a new to correct names.

    Luckily all speciments have a unique number, so if I could make a comparison between the two sheets and then make a copy from the original of all the unique values (this should be the entire row of data, not just the number)
    I should end up with all the missing records.

    But I have no idea of how to do it.
    So please help. It will be greatly appreciated
    Thanks
    Last edited by Anathil; April 4th, 2016 at 04:01 AM.

Similar Threads

  1. What is 'Operation Twist'? A Q&A on US Fed program
    By RSS_News_User in forum Business News
    Replies: 0
    Last Post: June 20th, 2012, 04:00 PM
  2. Like they did last summer: Fed may Twist again
    By RSS_News_User in forum Business News
    Replies: 0
    Last Post: June 13th, 2012, 02:00 AM
  3. Autofill with a twist
    By emex in forum Microsoft Access Help
    Replies: 3
    Last Post: June 30th, 2011, 10:52 AM
  4. Autonumbering with a twist
    By Miche1eM in forum Microsoft Access Help
    Replies: 4
    Last Post: March 24th, 2009, 11:30 AM
  5. 301 redirect - WITH A TWIST
    By tpn in forum ASP Development
    Replies: 15
    Last Post: June 19th, 2008, 07:09 AM

IMN logo majestic logo threadwatch logo seochat tools logo