+ Reply to Thread
Results 1 to 5 of 5

Compare two lists in excel and create new list with missing values

  1. 11-20-2013, 04:54 PM #1
    brian53199
    brian53199 is offline
    Registered User
    Join Date
    11-05-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Question Compare two lists in excel and create new list with missing values

    Hello,
    I am trying to take the names in column A of the "Passed" worksheet that are manually copied there and compare them to the names automatically pulled in "Testing Pipeline" column A so that when the "Testing Pipeline" column A is updated, the names that are there and not in the "Passed" worksheet are copied to the "Missing TMs" list on the "Passed" worksheet. I thought I found a solution using 2 helper columns, as I used in the "Roster" spreadsheet, but for some reason that isn't working so I deleted it and left the columns in case they'd be helpful to anyone. Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 11-20-2013, 07:54 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Compare two lists in excel and create new list with missing values

    In your example, Testing Pipeline Column A and Passed Column A are exactly the same, so there are no missing names;
    So I added a name for testing purposes and came up with this in D4 of Passed:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Drag down
    This gets missing names, and puts them where they are found in column D of passed, however, I suspect you want them consolidated, so I will be using 1 of your helper columns for final result
    Last edited by dredwolf; 11-20-2013 at 07:57 PM.
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  3. 11-20-2013, 08:19 PM #3
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Compare two lists in excel and create new list with missing values

    Okay, this in E4 of Passed sheet :
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    this in D4 :
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    drag both down as far as needed

    Hope this helps
    Reply With QuoteRegister To Reply
  4. 11-21-2013, 11:11 AM #4
    brian53199
    brian53199 is offline
    Registered User
    Join Date
    11-05-2013
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Compare two lists in excel and create new list with missing values

    Yeah, that worked great. Thank you!
    Reply With QuoteRegister To Reply
  5. 11-21-2013, 12:32 PM #5
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Compare two lists in excel and create new list with missing values

    You are welcome
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Compare two lists and copy unique values to the second list
    By Brumbot in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-06-2013, 07:36 AM
  2. compare 2 columns and create new column with missing values in second column
    By Jroelan2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-27-2012, 12:33 AM
  3. compare two lists and create a third with the difference
    By pancho villa in forum Excel General
    Replies: 3
    Last Post: 03-07-2010, 02:01 AM
  4. [SOLVED] Compare 2 columns, and create a list of items that are in both lists
    By ruby2sdy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-08-2005, 07:05 AM
  5. Excel Compare values in columns & display missing values in a new
    By cpetta in forum Excel General
    Replies: 1
    Last Post: 04-02-2005, 01:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1