+ Reply to Thread
Results 1 to 4 of 4

selecting specific cells from a matrix

  1. #1
    Registered User
    Join Date
    10-13-2009
    Location
    College Station, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    selecting specific cells from a matrix

    I am working on a large matrix. It is lower-triangular, meaning that the diagonal entries are 0s, and everything above the diagonal is blank. Each cell below the diagonal has a particular value (numeric).
    I want to pick a series of entries, e.g., (row #10, column # 20), (row#25, col#55), (row#105, col#50), and so on ... and save them as a new column.
    Right now I am doing this manually. Is there a better and more efficient way to accomplish this?
    Thanks.

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

    Re: selecting specific cells from a matrix

    Possibly but...

    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.

  3. #3
    Registered User
    Join Date
    10-13-2009
    Location
    College Station, USA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: selecting specific cells from a matrix

    Hi,
    I figured that I could post an attachment here.
    The sample file has a matrix.
    The cells I am looking to select are colored in red. Their "address" (i.e., row # and column #) are also listed.
    Attached Files Attached Files

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: selecting specific cells from a matrix

    In D20 and copy down, =INDEX($B$2:$P$16, B20, C20)
    Entia non sunt multiplicanda sine necessitate

+ 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