+ Reply to Thread
Results 1 to 3 of 3

Two dimensional table

  1. 03-06-2010, 09:59 AM #1
    ElmerS
    ElmerS is offline
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Two dimensional table

    Hi,

    I'm trying to produce, starting at A1, the requested matrix (see picture) but something is wrong with my formula.

    Thanks, Elm
    Attached Images Attached Images
    Last edited by ElmerS; 03-06-2010 at 11:06 AM.
    Reply With QuoteRegister To Reply
  2. 03-06-2010, 10:34 AM #2
    trucker10
    trucker10 is offline
    Forum Contributor trucker10's Avatar
    Join Date
    07-22-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003 / 2007 / 2010 prof +
    Posts
    149

    Re: Two dimensional table

    Quote Originally Posted by ElmerS View Post
    Hi,

    I'm trying to produce, starting at A1, the requested matrix (see picture) but something is wrong with my formula.

    Thanks, Elm
    Trye this
    =(COLUMN()+3*((ROW()+2-3)))
    suc6
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-06-2010, 11:06 AM #3
    ElmerS
    ElmerS is offline
    Forum Contributor
    Join Date
    11-28-2008
    Location
    Reykjavík, Iceland
    MS-Off Ver
    Any of: 2003 & 2007
    Posts
    412

    Re: Two dimensional table

    That helped.

    Thanks a lot, Elm
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1