+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Making a blank array

  1. #1
    Registered User
    Join Date
    06-03-2010
    Location
    saskatoon , Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Making a blank array

    Hi all,
    I wish to make a blank sheet starting in A1 with the co-ordinates of 0,0 and ending with 749.749. I can get the vertical cells to autofil with no problem. However the horizontal will not follow the correct sequence. I want it to go 0,0 :1,0:2,0:etc but it always tries to go 0,0: 0,1:0,2 etc
    So what am I doing incorrectly ?
    Thank you

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Making a blank array

    Not very clear... you're populating a matrix of 750x750 using formulae ?

    A1: =COLUMNS($A1:A1)-1&","&ROWS(A$1:A1)-1
    applied to A1:ABV750

    might take a little while to calculate the 500k+ cells

    It might be better to store row values (0-749) in say A2:A751 and Column Values (0-749) in B1:ABW1 then:

    B2: =B$1&","&$A2
    applied to matrix B2:ABW751 - avoids repetitive calcs.

  3. #3
    Registered User
    Join Date
    06-03-2010
    Location
    saskatoon , Canada
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Making a blank array

    Quote Originally Posted by DonkeyOte View Post
    Not very clear... you're populating a matrix of 750x750 using formulae ?

    A1: =COLUMNS($A1:A1)-1&","&ROWS(A$1:A1)-1
    applied to A1:ABV750

    might take a little while to calculate the 500k+ cells

    It might be better to store row values (0-749) in say A2:A751 and Column Values (0-749) in B1:ABW1 then:

    B2: =B$1&","&$A2
    applied to matrix B2:ABW751 - avoids repetitive calcs.
    Well really all I want to do is make up this matrix with those titles in each cell. No calculating is going to take place. I will be entering data individually in each cell. If you like it will be like a map.with each cell holding an address . in the form xxx,xxx
    Thanks you Donkeyote for your remarks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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