Welcome Guest
You last visited January 17, 2017, 2:51 am
All times shown are
Eastern Time (GMT-5:00)

Topic closed. 23 replies. Last post 7 years ago by DMW774.

 Page 1 of 2
Phoenix, AZ
United States
Member #70984
February 16, 2009
21 Posts
Offline
 Posted: February 11, 2010, 9:09 am - IP Logged

I have a list of numbers and I need to know how many times each number is followed by all the other numbers (or the same number). In other words, I need to know how many times 1 is followed by 1, how many times 1 is followed by 2, how many times 1 is followed by 3, etc.

Thanks

He who says deafness is a disability is under the false impression that he is saying something worth hearing.

north carolina/virginia
United States
Member #2097
August 17, 2003
126 Posts
Offline
 Posted: February 11, 2010, 9:31 am - IP Logged

=COUNTIF(\$D\$3:\$F:\$F,"=0")+COUNTIF(\$D\$3:\$F:\$F,"=1")  I am still working on this formula myself.  \$D\$3:\$F:\$F is the columns I entered the drawn digits in.

Chief Bottle Washer
New Jersey
United States
Member #1
May 31, 2000
23345 Posts
Offline
 Posted: February 11, 2010, 11:40 am - IP Logged

I have a list of numbers and I need to know how many times each number is followed by all the other numbers (or the same number). In other words, I need to know how many times 1 is followed by 1, how many times 1 is followed by 2, how many times 1 is followed by 3, etc.

Thanks

Excel is great for these kinds of things, because you don't need 10,000 different software packages, each with their own errors and quirks and features.  Excel is a lottery player's best friend.

If you don't know how to work with numbers, combos, and digits in Excel, then learn!  There are tons of books on the market, and all you have to do to get started is fire it up and start playing around.

Plus, it comes with lots of built-in help and tutorials, and the Microsoft site has lots of great tutorials, even advanced ones.

Check the State Lottery Report Card

Sign the Petition for True Lottery Drawings
Help eliminate computerized drawings!

Phoenix, AZ
United States
Member #70984
February 16, 2009
21 Posts
Offline
 Posted: February 12, 2010, 1:12 am - IP Logged

=COUNTIF(\$D\$3:\$F:\$F,"=0")+COUNTIF(\$D\$3:\$F:\$F,"=1")  I am still working on this formula myself.  \$D\$3:\$F:\$F is the columns I entered the drawn digits in.

Perhaps I should clarify. I took the first column of my local pick 3 and determined whether each number was high or low, even or odd, and had a skip above or below 6. I then assigned each circumstance a number. So, if it is a high, odd number with a skip ABOVE 6, it was assigned one number, but if it is a high, odd number with a skip BELOW 6, it was assigned a different number. Hence, my "list" is entirely within column A, in Excel.

What I need to know is what numbers follow eachother on such a list.

Thanks.

He who says deafness is a disability is under the false impression that he is saying something worth hearing.

Phoenix, AZ
United States
Member #70984
February 16, 2009
21 Posts
Offline
 Posted: February 12, 2010, 1:13 am - IP Logged

Excel is great for these kinds of things, because you don't need 10,000 different software packages, each with their own errors and quirks and features.  Excel is a lottery player's best friend.

If you don't know how to work with numbers, combos, and digits in Excel, then learn!  There are tons of books on the market, and all you have to do to get started is fire it up and start playing around.

Plus, it comes with lots of built-in help and tutorials, and the Microsoft site has lots of great tutorials, even advanced ones.

Any websites out there that deal specifically with using Excel for the purpose of gathering stats on the lotto/lottery?

He who says deafness is a disability is under the false impression that he is saying something worth hearing.

north carolina/virginia
United States
Member #2097
August 17, 2003
126 Posts
Offline
 Posted: February 12, 2010, 11:37 am - IP Logged

I understand what you are saying, I am still working on something similar, where you track the digit that follows a certain digit. Could'nt you enter the cells you desire in this formula?  I got this formula from typing in 'formulas for Excel" or countif formulas in the google search bar.

United States
Member #47420
November 4, 2006
3930 Posts
Offline
 Posted: February 12, 2010, 12:11 pm - IP Logged

=COUNTIF(\$D\$3:\$F:\$F,"=0")+COUNTIF(\$D\$3:\$F:\$F,"=1")  I am still working on this formula myself.  \$D\$3:\$F:\$F is the columns I entered the drawn digits in.

I read some of these post like this and have no idea what they mean then someone says they will clarify it for you and that makes it even worse..I feel so dumb reading some post..Beam me up Scotty..Good luck is what it is in the end..

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5961 Posts
Offline
 Posted: February 12, 2010, 12:19 pm - IP Logged

Perhaps I should clarify. I took the first column of my local pick 3 and determined whether each number was high or low, even or odd, and had a skip above or below 6. I then assigned each circumstance a number. So, if it is a high, odd number with a skip ABOVE 6, it was assigned one number, but if it is a high, odd number with a skip BELOW 6, it was assigned a different number. Hence, my "list" is entirely within column A, in Excel.

What I need to know is what numbers follow eachother on such a list.

Thanks.

Can you post an image of the worksheet?

Phoenix, AZ
United States
Member #70984
February 16, 2009
21 Posts
Offline
 Posted: February 13, 2010, 5:23 am - IP Logged

Can you post an image of the worksheet?

Open a spreadsheet and start at A1, typing a number between 1-8, and hit Enter each time, so that everything stays in column A. That would make a pretty close approximation of my worksheet.

He who says deafness is a disability is under the false impression that he is saying something worth hearing.

Phoenix, AZ
United States
Member #70984
February 16, 2009
21 Posts
Offline
 Posted: February 13, 2010, 5:31 am - IP Logged

I understand what you are saying, I am still working on something similar, where you track the digit that follows a certain digit. Could'nt you enter the cells you desire in this formula?  I got this formula from typing in 'formulas for Excel" or countif formulas in the google search bar.

Entering the cells I want to look at seems kind of silly. I want to look at all of them. I want to see which numbers come after eachother. If I only wanted to see what comes after 1, I would still have to look over the whole thing to find the cells with 1 in them. I may as well do that by hand.

As for the use of countif formulas, I am not familiar with that. I will see if I can find something close to what I'm looking for and get back to you. Thanks.

He who says deafness is a disability is under the false impression that he is saying something worth hearing.

north carolina/virginia
United States
Member #2097
August 17, 2003
126 Posts
Offline
 Posted: February 13, 2010, 11:06 pm - IP Logged

Please don't feel that way, I responded in a quick way thinking the other person was familiar with the formulas for excel,  I am still learning Excel myself.  I was hoping to put our heads together so we can figure out a formula for myself.

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5961 Posts
Offline
 Posted: February 14, 2010, 7:23 am - IP Logged

Entering the cells I want to look at seems kind of silly. I want to look at all of them. I want to see which numbers come after eachother. If I only wanted to see what comes after 1, I would still have to look over the whole thing to find the cells with 1 in them. I may as well do that by hand.

As for the use of countif formulas, I am not familiar with that. I will see if I can find something close to what I'm looking for and get back to you. Thanks.

The image is only for position 1, the formula below is telling how many times the digits going across have followed the digits going down, for position 1 only. The others will have to be created, by changing the ranges.

=SUMPRODUCT(--(\$W\$14:\$W\$115=AC\$14),(--(\$W\$15:\$W\$116=\$AB15)))

NASHVILLE, TENN
United States
Member #33372
February 20, 2006
1044 Posts
Offline
 Posted: February 14, 2010, 7:32 am - IP Logged

The image is only for position 1, the formula below is telling how many times the digits going across have followed the digits going down, for position 1 only. The others will have to be created, by changing the ranges.

=SUMPRODUCT(--(\$W\$14:\$W\$115=AC\$14),(--(\$W\$15:\$W\$116=\$AB15)))

After entering all your numbers by hand, you can sort the column.  Look to the far

right side of the tool bar (the very top of the page).  You will see AZ.  This is your

sort button.  Click on the cell of the column (such as A1), then click on AZ.  All the columns will line up

numerically and you can see which numbers follow what.  This will not work if you

have a blank column between the numbers.  Keep all the numbers in adjacent cells.

Chicago
United States
Member #70678
February 8, 2009
889 Posts
Offline
 Posted: February 14, 2010, 9:27 am - IP Logged

I read some of these post like this and have no idea what they mean then someone says they will clarify it for you and that makes it even worse..I feel so dumb reading some post..Beam me up Scotty..Good luck is what it is in the end..

Don't feel bad I have Exel on my computer and I even found an easy tutorial to follow.......LOL and when I finally win the lottery maybe I'll have the time to actually sit down and figure out how to use it. For now everything is paper and pencil.

New Jersey
United States
Member #17843
June 28, 2005
50995 Posts
Offline
 Posted: February 14, 2010, 9:33 am - IP Logged

I understand what you are saying, I am still working on something similar, where you track the digit that follows a certain digit. Could'nt you enter the cells you desire in this formula?  I got this formula from typing in 'formulas for Excel" or countif formulas in the google search bar.

Thanks for sharing!

Are you using a Matrix for the results? Each axis would have 0>9

Then using =match and =countif in each cell of the matrix would provide the count

A mind once stretched by a new idea never returns to its original dimensions!

 Page 1 of 2