+ Reply to Thread
Results 1 to 3 of 3

Matrix Array

  1. #1
    Registered User
    Join Date
    11-07-2011
    Location
    Portland, OR
    MS-Off Ver
    Excel 2011 Mac
    Posts
    1

    Matrix Array

    Hi,

    I'm trying to generate an array that has XYZ coordinates for the columns and rows. I've successfully generated a formula to calculate the distance between each point. But what I cannot do is drag this formula to other columns or rows without having to edit it each time. The default adjustment to the formula makes it draw data from completely incorrect columns/rows. There being several hundred columns and rows, I would prefer not to edit it almost 10000 times. Any comments, tips would be greatly appreciated.


    -Sam

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    34,251

    Re: Matrix Array

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Matrix Array

    Make the references 'fixed' by using the $ sign (which currency by the way isn't very fixed at all)

    e.g. instead of A1 use $A$1



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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