+ Reply to Thread
Results 1 to 6 of 6

Stack 2 Lists to Match

  1. #1
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Stack 2 Lists to Match

    Hi, I have 2 lists that are both contain 3 columns worth of data. The first list is list A, the second is list B. See file below.

    List A has more rows worth of data that list B. For every row of data in list B, there should be a match in List A. I simply need to rearrange list B so that it has its matching entry in list A. When this happens the "CHECK" column should be all zeros.

    test.xlsx

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Stack 2 Lists to Match

    Hi, Ref the attachment...
    Attached Files Attached Files
    Click just below left if it helps, Boo?ath?

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Stack 2 Lists to Match

    thanks very much for this, I suppose I could just sort by Diff1 to get the matchup ... I sure wish I understood what you did so I can do it myself or would it take all day to explain lol?

  4. #4
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Stack 2 Lists to Match

    Hi, Used multiple consildation ranges, combine a1&a2 and b1 and b2 to get the common rowlable for both ranges,

    Ref the below link
    http://www.contextures.com/xlPivot08.html

  5. #5
    Registered User
    Join Date
    09-05-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    71

    Re: Stack 2 Lists to Match

    thanks very much!

  6. #6
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: Stack 2 Lists to Match

    HI, Thanks for the feed back and rep

+ 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. VBA- Match two lists
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-23-2012, 05:31 PM
  2. Match two lists and sum
    By Azam Ali in forum Excel General
    Replies: 9
    Last Post: 07-13-2011, 02:38 AM
  3. Match between two lists
    By penumbra547 in forum Excel General
    Replies: 7
    Last Post: 05-05-2009, 11:43 PM
  4. [SOLVED] I am trying to match 2 lists
    By Smish in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-18-2005, 04:35 PM
  5. [SOLVED] If two lists don't match
    By achidsey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2005, 12:30 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