• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combine Inputs

navneet

New Member
hi

i have just joined the forum. i have one query.
suppose i have sheet1 which is having thousands of other data.
there are 4 input parameters which change the 3 output parameters of the sheet1.
i have 256 combination of these 4 inputs.
intead of changing these 4 input parameters every time manually.
i wish that i place 256 combination of input parameters in sheet2 and all 256 types of 3 output
parameters should be visible against each input in sheet2.

how can i do this.
 
Can you tell us what the inputs are? Or do you just want to know how to create 256 combinations?

If the latter, let's say your parameters are in a range called MyList.
Start with this formula:
=INDEX(MyList,MOD(INT((ROWS(A$1:A1)-1)/ROWS(MyList)^(COLUMNS($A$1:A$1)-1)),ROWS(MyList))+1)

Copy to the right as many columns = # of rows in MyList, and then down as many rows as would be necessary (in your case, 4^4 = 256 rows).
 
Back
Top