+ Reply to Thread
Results 1 to 2 of 2

deleting matrix value

  1. #1
    Registered User
    Join Date
    02-11-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    98

    deleting matrix value

    basically I have a 300x300 matrix. I am trying to deleting the values i do not need to speed up the calculation process. creating the matrix was easy but i need help w/ a loop to delete what i do not need. for example...

    time along the y axis
    Asset # along the x axis

    i am have values for asset 'n' throughout time, from t=0 to t=300 but i only need the change in time from t=0 to t=1. so i am trying to delete everything below t=1. asset 2 is a similar story..

    i am trying to look at the change in asset value from time 1 to time 2. [i.e delete everything below time 2 etc... for all 300 assets. right now i have just found the 1st and last columns and rows respectively. i am struggling w/ how to run two loops at once.

    help would be fantastic. please and thanks
    Last edited by dabrows; 05-26-2011 at 02:58 PM.

  2. #2
    Registered User
    Join Date
    02-11-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    98

    Re: deleting matrix value

    here is my code that doesn;t want to work for me. the column loop work well, but the row loop doesn;t want to work... the range isn;t getting smaller

    Please Login or Register  to view this content.

+ 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