+ Reply to Thread
Results 1 to 3 of 3

Create one array from two columns with different size

  1. #1
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Create one array from two columns with different size

    Hello everyone
    I have five elements in column A range("A1:A5") {Doctor , Teacher , Bachelory , Diploma , Thanwya}
    And in Column B I have three elements in B1:B3 {Saudi , Arabian, Non-Arabin}

    I need to create a combination of the two arrays in one array ..
    In other words to create an array which has the elements : {Doctor Saudi, Doctor Arabian, Doctor Non-Arabin, Teacher Saudi and so on .....}

    If possible do without ranges to store values of the arrays.. that's to deal with the arrays like this
    Arr1=Array("Doctor", "Teacher", "Bachelory", "Diploma", "Thanwya")
    Arr2=Array("Saudi", "Arabian","Non-Arabian")

    Hope it is clear
    Last edited by YasserKhalil; 08-08-2015 at 05:58 PM.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Create one array from two columns with different size

    Thanks I could solve it myself
    Please Login or Register  to view this content.
    Last edited by YasserKhalil; 08-08-2015 at 06:16 PM.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Create one array from two columns with different size

    To be more flexible, you could change this

    Please Login or Register  to view this content.
    to this

    Please Login or Register  to view this content.

+ 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. Replies: 9
    Last Post: 05-18-2023, 07:18 PM
  2. [SOLVED] Create an array for filtered and non-contiguous columns
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-28-2015, 04:39 PM
  3. Replies: 6
    Last Post: 09-25-2013, 10:08 PM
  4. [SOLVED] Array size unknown until the first "loop", how to correction dim/redim the array
    By menichols74 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2013, 10:04 AM
  5. Create an array based off values in another array - exclude blanks
    By clifton1230 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 05:35 PM
  6. macro to put zero's in table array - table array will vary in size each time
    By leanne2011 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2012, 06:12 AM
  7. Assign sheet value to array... and redim the array size
    By Orange.CL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-27-2010, 07:18 AM

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