+ Reply to Thread
Results 1 to 5 of 5

Create array of items which are in List A but not present in List B

  1. 06-06-2018, 12:26 AM #1
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Create array of items which are in List A but not present in List B

    Hi

    I have 2 arrays (1D) in the attached I want to compare both ones and create a 3rd Array that will contain those items which are present in A List and not present in List B

    Best Regards
    Imran Bhatti
    Attached Files Attached Files
    Teach me Excel VBA
    Reply With QuoteRegister To Reply
  2. 06-06-2018, 12:50 AM #2
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Create array of items which are in List A but not present in List B

    You may try something like this...

    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  3. 06-06-2018, 01:07 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,519

    Re: Create array of items which are in List A but not present in List B 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 06-06-2018, 01:21 AM #4
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Create array of items which are in List A but not present in List B

    Quote Originally Posted by jindon View Post 
    Please Login or Register  to view this content.
    A shorter solution. Appreciated....can quickly convert the e from collection to array as later on I want to use this third array in autofilter?
    without placing it on the worksheet.
    Reply With QuoteRegister To Reply
  5. 06-06-2018, 01:28 AM #5
    ImranBhatti
    ImranBhatti is offline
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Create array of items which are in List A but not present in List B

    sorry for the silly question I just did it by replacing this line 
    Please Login or Register  to view this content.
    with this
    Please Login or Register  to view this content.
    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] Formula to create list of items selected for reports (array formula?)
    By Cidona in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-06-2018, 02:09 AM
  2. Need to create a form that can accept user ID and then display list of check list items
    By aleanboy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-05-2014, 09:38 AM
  3. [SOLVED] How to Compare two lists to create a list of items to another list?
    By alcorp in forum Excel General
    Replies: 4
    Last Post: 06-30-2014, 11:13 AM
  4. [SOLVED] How to shorten code into an array to create a list of items separated by commas
    By mdovey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2014, 12:23 PM
  5. [SOLVED] Using an array to create a list of selected items
    By Harribone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2014, 04:40 PM
  6. Create a list of items based on another list
    By rickyg in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-10-2010, 09:57 AM
  7. How to create a list of items for use in a dropdown list with data from a different..
    By nasser in forum Excel General
    Replies: 10
    Last Post: 03-19-2007, 11: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1