+ Reply to Thread
Results 1 to 11 of 11

Compare two list

  1. #1
    Forum Contributor
    Join Date
    03-17-2010
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    113

    Compare two list

    Hello
    I need help with this situation
    I have two lists list1 and list2 i want a formula that compare list one to list two show list1 values that are not in
    list 2.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Compare two list

    How do you want them shown? A separate list? or just highlight the ones that are not in List 2?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    03-17-2010
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: Compare two list

    Separate list

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Compare two list

    Hi Sohaila,

    I can do you problem if we get to have Helper Columns. See the attached with my answer. Will you allow helper columns? If not then keep asking. See the attached for my answer.
    Toss Dups with Dups.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Compare two list

    Duplicate removed by FR.
    Last edited by FlameRetired; 03-27-2020 at 05:30 PM.
    Dave

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Compare two list

    sohaila please update your profile. The format of the file you've uploaded is from a newer version than Excel 2003. Members consider this when offering solutions.

    If you are not familiar with how to update your profile find the dark blue menu at the top of this page that says
    Forum Actions
    . Click that and 'Edit Profile'.

    That said try array entering this formula in D2 and fill down.

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Compare two list

    Please disregard my formula in post #6. I misread the instructions and upload. Array enter this instead.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Compare two list

    Hi Dave,

    I put a "300" in A8 and ran your formula against the new List1. I'm thinking it should show 300 twice for the answer. I wonder if your answer is acceptable for the OP? I used the formula in post 7 above.

  9. #9
    Forum Contributor
    Join Date
    03-17-2010
    Location
    karachi
    MS-Off Ver
    Excel 2003
    Posts
    113

    Re: Compare two list

    Thanks All of you for your reply second formula of flameretired is work perfectly.

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Compare two list

    @Marvin

    Yeah I wasn't altogether confident I had interpreted instructions correctly either. So I did 'wait-and-see' too.

  11. #11
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: Compare two list

    You are welcome sohaila. Glad to help. Thank you for the feedback and marking your thread Solved.

    Please update your profile.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup when list is inconsistant length and compare list is not exact
    By Thom7890 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2018, 02:08 PM
  2. [SOLVED] Compare a list of strings against a list of keywords to return a partial match
    By randomkiwi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-11-2017, 11:51 PM
  3. Compare Range list with String Array list (both same # of values)
    By mgmAB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2016, 06:58 AM
  4. [SOLVED] compare list B with list A, return cell data on row where B matched A
    By master-richie in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-04-2015, 01:59 AM
  5. Replies: 4
    Last Post: 06-30-2014, 11:13 AM
  6. [SOLVED] Compare two names list and compare other column aftrerwards
    By badboynads in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-25-2013, 12:46 PM
  7. Compare List A to List B and Return Duplicates to C
    By nexttech in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2009, 11:58 PM

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