• 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.

VBA. Counting

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]]
1​
2​
3​
4​
5​
6​
7​
etc….
1​
2​
3​
etc…..
 

Attachments

Top