+ Reply to Thread
Results 1 to 5 of 5

Assistance needed with arrays

  1. #1
    Registered User
    Join Date
    03-14-2007
    Posts
    16

    Assistance needed with arrays

    I'm trying to modify the sub routine below to output the none matching values between the elements in the arrays. so the output should be:
    7-3-2-8 as 7-3 is the first array followed by the difference between both arrays.

    Any help is as always appreciated.

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 11-01-2016 at 10:00 PM. Reason: Added Code Tags

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Assistance needed with arrays

    Quote Originally Posted by doctorcpu View Post
    so the output should be:
    7-3-2-8 as 7-3 is the first array followed by the difference between both arrays.
    Please Login or Register  to view this content.

  3. #3
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Assistance needed with arrays

    In this UDF method, if section is missing, the dash is there but no value after. To sort properly, you should poke each of the 3 into their own column.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-14-2007
    Posts
    16

    Re: Assistance needed with arrays

    AWESOME!!!!!!!!!

    Thanks,

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Assistance needed with arrays

    If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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. Download and combine Multiple Basic HTML Pages into an Excel Workbook
    By bugpro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-21-2016, 03:15 PM
  2. [SOLVED] Request: Assistance with arrays
    By seangun in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-27-2016, 01:25 PM
  3. Finding relevant salary using Arrays - Partial VBA code written/ Need Assistance
    By UMBiii in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2014, 02:26 PM
  4. HELP... Assistance needed Please!
    By MChase in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-23-2012, 11:08 AM
  5. Code assistance needed
    By JimMay in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-07-2006, 06:20 AM
  6. VBA Assistance Needed
    By RalphB in forum Excel General
    Replies: 5
    Last Post: 02-22-2006, 02:20 PM
  7. [SOLVED] Code assistance needed
    By HJ in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-27-2005, 12:05 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