+ Reply to Thread
Results 1 to 3 of 3

permutationally shifting the function of a row one column

  1. #1
    Registered User
    Join Date
    12-02-2009
    Location
    New Haven, CT
    MS-Off Ver
    Excel 2008 for Mac
    Posts
    1

    permutationally shifting the function of a row one column

    I'm not exactly sure how to explain this, but I'll do my best:
    Row 1 contains numeral data in each column
    Each column of Row 2 contains the results of functions applied to the data in the corresponding column of Row 1. The data of Row 2 then gets incorporated into a further function.

    I want to be able to shift the functions of Row 2, such that they will rotate through the data of every column in Row 1. This will, of course, create different results in my "further function." Each of these different results needs to participate in a final calculation.

    Is there a function that I can apply to my initial setup to rotate my data?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: permutationally shifting the function of a row one column

    Hi,

    Your problem will be a lot easier to understand and solve if you supply a small data sample in a workbook. You can upload a file by clicking "Go Advanced" below and then the paper clip icon. Make sure to supply a "before" and "after" scenario and explain the logic that leads to the solution.

    cheers

  3. #3
    Forum Expert
    Join Date
    01-03-2006
    Location
    Waikato, New Zealand
    MS-Off Ver
    2010 @ work & 2007 @ home
    Posts
    2,243

    Re: permutationally shifting the function of a row one column

    hi Chris,

    As Teylyn suggests, it will be easier for us to help if you upload a sample file. In the mean time, or if you want to research a possible solution (?), look up the "Choose" &/or preferably the "Index" function in the Excel Help files.

    hth
    Rob
    Rob Brockett
    Kiwi in the UK
    Always learning & the best way to learn is to experience...

+ 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