Excel - Removing duplicates in lists (perhaps comparing?)

Posted on 2012-09-07
Last Modified: 2012-11-01

I have 2 lists of students from 2 dates. List 1 contains students enrolled on 2nd September. List 2 has list of students enrolled on 6th September.

I have inputted the students from List 1 into our own departmental database, and need to enter the people enrolled in the days after 2nd September from the 6th September list (List 2).

I have messed about with duplicates and filters, but cannot quite find what i need to solve this puzzle!

Is there a straightforward way to highlight the differences between the 2 lists as list 2 contains list 1 plus new enrollees?

Thanks for your help in advance

Question by:Concept_Wes
    LVL 19

    Assisted Solution

    I would use VLOOKUP formula. and then filter people on 6.9. sheet who have "was not" value
    is this valuable for you
    LVL 25

    Accepted Solution

    You could use a VLOOKUP to find of the entry in list 2 exists in list 1.
    LVL 19

    Expert Comment

    hey Wesley, did you achieve your goal with this?

    Author Closing Comment

    So sorry guys - thanks for the help - perfect answer!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    Best, Average or Worst ? 12 55
    Change and Add Hyperlinks in Excel 6 32
    how to link excel with word 6 29
    VBA Help TT V-1.1 15 22
    This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
    Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now