vicktor schausberger
Member
Hello to all the Always Great people in this Excellent Forum.
I have an 2D dynamic array with the numbers from 1 to 53 in six columns by 2632 rows at this moment.
What I would like to see is a matrix that show me, how many times number 1 go to 1 in the next cells, go to 2 and so on and the same for each number, the code will run column by column the same, starting at the button to the top (from row 2632 to row 1) on each column. This is a random generated array so you will see for example from one cell to the next cell a behave like 1-1-10-3-20-1 etc. so here for example the code will count from 1 to 1 one time, 1 to 10 one, 10 to 3 one, 3 to 20 one, 20 to 1 one etc. etc.
The expected logic for each column is, the first will go only from 1 to 48 the second from 2 to 49 the third from 3 to 50, 4-51, 5-52 and 6 – 53.
Example of the report could be start at Sheet2, B2
[[ From 1 to 53 each side]]
I have an 2D dynamic array with the numbers from 1 to 53 in six columns by 2632 rows at this moment.
What I would like to see is a matrix that show me, how many times number 1 go to 1 in the next cells, go to 2 and so on and the same for each number, the code will run column by column the same, starting at the button to the top (from row 2632 to row 1) on each column. This is a random generated array so you will see for example from one cell to the next cell a behave like 1-1-10-3-20-1 etc. so here for example the code will count from 1 to 1 one time, 1 to 10 one, 10 to 3 one, 3 to 20 one, 20 to 1 one etc. etc.
The expected logic for each column is, the first will go only from 1 to 48 the second from 2 to 49 the third from 3 to 50, 4-51, 5-52 and 6 – 53.
Example of the report could be start at Sheet2, B2
[[ From 1 to 53 each side]]
1 | 2 | 3 | 4 | 5 | 6 | 7 | etc…. | |
1 | ||||||||
2 | ||||||||
3 | ||||||||
etc….. | ||||||||