I have a list of numbers and i am trying to build a grid that shows the number of times a value occurs after each number but only in the next 10 cells. I am at a loss as where to even start. It is a running list and i would like to do it for each number in the list. Example:
List: 1,2,7,4,5,6,6,8,9,0
2 occurs after 1 once
7 occurs after 1 once
6 occurs after 1 twice
4 occurs after 2 once
So on and so forth except it would be built in a grid and for a few thousand numbers ranging from 0 to 50
List: 1,2,7,4,5,6,6,8,9,0
2 occurs after 1 once
7 occurs after 1 once
6 occurs after 1 twice
4 occurs after 2 once
So on and so forth except it would be built in a grid and for a few thousand numbers ranging from 0 to 50