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

Program or Spreadsheet

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

Page 1 of 2
PrintE-mailLink
Avatar
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.

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

      Todd's avatar - Cylon 2.gif
      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
      What grade did your lottery earn?

       

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

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

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

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

              tiggs95's avatar - Lottery-036.jpg

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

                CARBOB's avatar - FL LOTTERY_LOGO.png
                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?

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

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

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

                        CARBOB's avatar - FL LOTTERY_LOGO.png
                        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)))

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

                            ca-dreamin*'s avatar - Lottery-065.jpg
                            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.

                              Raven62's avatar - binary
                              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!