Jamaica
Member #185,098
October 14, 2017
4 Posts
Offline
Hello everybody, hope you are all having a great day. I am wondering if someone can be kind enough to help me with by problem.
I would appreciate an excel formula/macro/vba. etc. that can extract all the numbers that follow a particular number. In the example here, i have highlighted the number 6 and i would like to:
a). Find all the numbers that occurs after the number 6 occurs in the next row above
b). Count the frequency such number occurs after 6.
Gladly appreciate any help given. Thanks in advance.
California United States
Member #167,122
June 27, 2015
1,637 Posts Online
Quote: Originally posted by frank141 on Feb 4, 2019
Hello everybody, hope you are all having a great day. I am wondering if someone can be kind enough to help me with by problem.
I would appreciate an excel formula/macro/vba. etc. that can extract all the numbers that follow a particular number. In the example here, i have highlighted the number 6 and i would like to:
a). Find all the numbers that occurs after the number 6 occurs in the next row above
b). Count the frequency such number occurs after 6.
Gladly appreciate any help given. Thanks in advance.
5
4
2
6
6
8
8
8
5
5
6
1
6
8
0
4
3
8
5
5
3
9
4
0
6
1
4
9
7
7
9
1
3
7
9
2
4
8
8
7
0
2
2
5
3
5
6
1
1
1
8
9
3
9
3
8
1
6
8
2
3
5
1
9
4
7
9
0
4
4
4
3
4
1
1
0
8
9
1
8
4
1
2
2
6
9
3
2
9
4
3
9
0
0
0
3
8
4
1
1
6
7
9
8
3
9
7
7
4
6
2
5
0
4
3
9
2
2
0
3
6
3
5
8
1
8
9
6
9
1
2
6
0
5
9
2
8
8
0
9
6
8
6
9
6
5
3
6
2
7
4
4
3
4
9
6
0
5
2
2
3
0
4
2
3
0
9
7
3
5
4
3
1
3
1
9
5
5
4
7
0
3
9
9
9
3
6
4
8
9
3
7
2
8
5
9
1
5
2
9
6
9
9
3
9
6
5
6
2
4
6
2
6
9
4
0
3
4
1
7
9
9
1
3
8
0
6
8
0
2
1
4
2
0
5
2
8
9
0
7
4
7
0
7
0
6
3
9
5
4
2
9
3
0
2
4
8
7
8
6
8
2
5
0
7
0
5
2
1
6
0
2
6
5
7
8
5
6
4
9
6
5
2
9
5
4
0
8
0
7
8
9
2
0
5
2
6
1
9
3
9
2
7
6
7
8
7
6
0
7
5
3
5
8
9
4
4
4
4
6
5
9
6
1
1
3
2
8
3
7
1
1
5
1
7
9
1
4
8
5
2
3
1
8
7
7
6
1
2
3
8
2
3
3
1
9
3
6
9
7
2
4
7
4
3
9
1
5
9
2
5
6
0
3
6
0
6
4
5
1
2
1
4
0
1
5
7
5
0
4
3
0
9
9
2
8
8
8
3
5
6
3
0
0
6
0
1
5
9
2
1
6
6
0
6
3
5
5
6
1
9
0
0
6
0
9
7
9
8
0
2
9
a). Find all the numbers that occurs after the number 6 occurs in the next row above.
Are You arranging the Draws with Ascending Order? Just Checking, I usually Set the most current Draw at the Top.
Are You Setting the Key Digit 6 in the First Column or are you Applying the Key 6 to all 4 Columns?
b). Count the frequency such number occurs after 6.
There are 2 Ways to do the Count. Total including Doubles or Games containing the Digit. Frequency generally refers to per Game, so I assume you want games containing the Digit whether it is a Single, Double or Triple.
Jamaica
Member #185,098
October 14, 2017
4 Posts
Offline
Thanks AllenB,
The most recent draws are on top
The key digit is in the first column only. I am more interested in the column that 6 occurs (in this case the first column), i want to find what number(s) occurs-follows after the number 6 is played in column 1.