Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Could someone help please
I m mathematician and would solve a problem I have, generating specific matrix for each integer n Could someone help me design a VBA prog that, for an integer n, generate a matrix M = [A(l,c)] with following specs: - M must be an n columns - A(l,c) must be smaller or equal to c for every c smaller or equal to n - for every l integer and c integer smaller or equal to n, the integer [ A(l,c) minus Max{1; 2; 3; ... A(l,c-1) ] is smaller or equal to 1 - no row is repeated Many thanks for any idea to solve the problem jiyed M AAanother description: - for an integer n, the matrix will be n-column - no row is repeated - for an integer c smaller or equal to n, the column c is populated by every integer smaller or equal to c - order of rows isn't important Many thanks for any idea to solve the problem jiyed M examples For n = 2, matrix is: 1 1 1 2 For n = 3, matrix is: 1 1 1 1 1 2 1 2 1 1 2 2 1 2 3 For n = 4, matrix is: 1 1 1 1 1 1 1 2 1 1 2 1 1 1 2 2 1 1 2 3 1 2 1 1 1 2 1 2 1 2 1 3 1 2 2 1 1 2 2 2 1 2 2 3 1 2 3 1 1 2 3 2 1 2 3 3 1 2 3 4 For n = 5, matrix is : 1 1 1 1 1 1 1 1 1 2 1 1 1 2 1 1 1 1 2 2 1 1 1 2 3 1 1 2 1 1 1 1 2 1 2 1 1 2 1 3 1 1 2 2 1 1 1 2 2 2 1 1 2 2 3 1 1 2 3 1 1 1 2 3 2 1 1 2 3 3 1 1 2 3 4 1 2 1 1 1 1 2 1 1 2 1 2 1 1 3 1 2 1 2 1 1 2 1 2 2 1 2 1 2 3 1 2 1 3 1 1 2 1 3 2 1 2 1 3 3 1 2 1 3 4 1 2 2 1 1 1 2 2 1 2 1 2 2 1 3 1 2 2 2 1 1 2 2 2 2 1 2 2 2 3 1 2 2 3 1 1 2 2 3 2 1 2 2 3 3 1 2 2 3 4 1 2 3 1 1 1 2 3 1 2 1 2 3 1 3 1 2 3 1 4 1 2 3 2 1 1 2 3 2 2 1 2 3 2 3 1 2 3 2 4 1 2 3 3 1 1 2 3 3 2 1 2 3 3 3 1 2 3 3 4 1 2 3 4 1 1 2 3 4 2 1 2 3 4 3 1 2 3 4 4 1 2 3 4 5 Many thanks in advance to help -- mathematitien |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Randomly Generate Specific Data | Excel Worksheet Functions | |||
How can I transpose nXm matrix to mXn Matrix | Excel Worksheet Functions | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
generate a random number and use if function to generate new data | Excel Worksheet Functions | |||
Matrix | Excel Discussion (Misc queries) |