+ Reply to Thread
Results 1 to 2 of 2

Comparing 2 Lists to Identify Differences

  1. #1
    Registered User
    Join Date
    12-10-2012
    Location
    Peru
    MS-Off Ver
    Excel 2010
    Posts
    3

    Comparing 2 Lists to Identify Differences

    I am trying to maintain an employee spreadsheet that is updated weekly. I can cut and copy the new updated worksheet into the same workbook as the original, so that I am working within the same workbook, but if this does not matter let me know. I have multiple columns such as last name, first name, id no, etc...I was wanting to use the id no as it is the most specific. So in my old list I have a total of 264 entries, in my new list I have a total of 260 entries. I am wanting to compare the 2 lists and identify the 4 additional entries in my old list. Thanks for any help, Orracle

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Comparing 2 Lists to Identify Differences

    see:

    http://www.excelforum.com/excel-gene...two-lists.html
    Gary's Student

+ 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