+ Reply to Thread
Results 1 to 3 of 3

Get the Difference between Two 2 D Arrays in VBA

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Get the Difference between Two 2 D Arrays in VBA

    HI all,
    I have two 2 Dimensional String Arrays with data. I need to find a way to get the difference between these two Arrays. I am new to VBA, I don't know how to deal with these. I certainly feel that there is some efficient function for doing this. or Is the naive two for lop concept is the only way to go?

    Thanks,
    Pavan

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Get the Difference between Two 2 D Arrays in VBA

    Pavan

    What exactly do you mean by 'difference'?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    08-07-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Get the Difference between Two 2 D Arrays in VBA

    Sry for missing that, when I say difference, I mean that the differences between the data in one array and other.
    Suppose Array A has 1,2,3,4,5 and B has 2,4,6,7,9

    I mean by difference is that 1,3,5....should be the Output.

    though I showed here the One Dimensional example. I need to do the same for 2 D Arrays.

    Except in case of 2 D Array I need to get the rows of which we have the difference items. Such as if we have a row with different data in both the arrays. I need that one.

    Hope I am clear now. If not let me know I would try to explain with an example.

+ 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] New to arrays-where do I find a good beginners guide to multi dimensional arrays
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-04-2013, 07:44 PM
  2. [SOLVED] Need to count if the difference in values between two arrays is less than 5
    By italianiceman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-07-2012, 03:08 PM
  3. Replies: 0
    Last Post: 10-07-2008, 10:45 PM
  4. [SOLVED] Arrays - declaration, adding values to arrays and calculation
    By Maxi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2006, 11:15 AM
  5. [SOLVED] VBA - averaging the difference of 2 arrays, ignoring blanks
    By RobPaolillo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-08-2005, 04:05 PM

Tags for this Thread

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