Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet Function (97)

    The subject may not be proper, but anyway, here is what I want to do. I want to generate a test matrix 64 by 16

    I have tried it that way, where from A1 ...A64(bk)
    1 2 3 ...

    I would like to know how can I do that

    a1 = (1,1)
    a2=(2,1) etc.

    here is how it would look like

    (1,1)
    (2,1)
    I want to do that just to the location of the element

  2. #2
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet Function (97)

    I would do it by using formulas refering to the values in the top row/side column. you can aways paste special to turn them into values after if you need to.


    HTH

    Peter

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet Function (97)

    You could put the formula below in A1 and then fill it down 64 rows and across 16 columns.

    <pre>="("&ROW()&","&COLUMN()&")"
    </pre>

    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •