New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Permutations that reach a desired value

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Permutations that reach a desired value

Postby RDuarte » Thu Jan 28, 2016 3:46 am

Hello, I need help to create a specific matrix.

I'will explain:

I want to create a four collum matrix filled with radom numbers between 1 and 6. This matrix should return all the possible permutations that the sum of each line may be equal to a specif number (for example 17).

I saw this link:

http://www.microsoftexcel.com.br/index. ... avras.html

However i want to return all the possibilities that reach a desired value in a kind of matrix.
Is this possible?

Hope you can help me.

Thanks in advance
  • 0

RDuarte
Rookie
 
Posts: 1
Joined: Jan 28, 2016
Reputation: 0
Excel Version: 2013

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 120 guests