Welcome Guest
Log In | Register )
You last visited December 8, 2016, 1:03 pm
All times shown are
Eastern Time (GMT-5:00)

excel formula needed

Topic closed. 12 replies. Last post 12 years ago by Littleoldlady.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: January 29, 2005, 9:53 pm - IP Logged

I have the following formula to set up for 3 digit using pos1, pos 2, and pos 3

=INT(B2/100)

=INT((B2-(C2*100))/10)

=INT((B2-((C2*100)+D2*10)))

Can anyone tell me what formula I would add to do my 4 digit data in this manner?

L ttaL   T

    undress's avatar - Lottery-061.jpg
    roseville, MI
    United States
    Member #5980
    July 30, 2004
    18205 Posts
    Offline
    Posted: January 29, 2005, 10:12 pm - IP Logged

    Lottaloot I would ask Sandy She's the excel wizard

    Mad ALL IN!Mad

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: January 29, 2005, 10:19 pm - IP Logged

      Thanks.  She's offline at present though so if anyone else knows please post

      L ttaL   T

        hypersoniq's avatar - 8ball
        Pennsylvania
        United States
        Member #1340
        April 6, 2003
        2450 Posts
        Offline
        Posted: January 30, 2005, 9:04 am - IP Logged

        Here is what I have

        Assuming Cell C is where you enter the 4 digit combo...

        in cell D ...  =INT(C2/1000)

        in cell E ...  =INT((C2-(D2*1000))/100)

        in cell F ...  =INT((C2-((D2*1000)+(E2*100)))/10)

        in cell G ...  =INT((C2-((D2*1000)+(E2*100)+(F2*10))))

        (i have draw date and draw number in columns A and B)

        Playing more than one ticket per game is betting against yourself.

          lottaloot's avatar - AvatarZ56
          Redford/MI
          United States
          Member #3396
          January 18, 2004
          4867 Posts
          Offline
          Posted: January 30, 2005, 11:03 am - IP Logged

          Thanks Hypersoniq.

           

          I think I found the above formulas in one of your previous posts.

          L ttaL   T

            lottaloot's avatar - AvatarZ56
            Redford/MI
            United States
            Member #3396
            January 18, 2004
            4867 Posts
            Offline
            Posted: February 10, 2005, 1:00 am - IP Logged

            If anyone knows a formula that will give a total return number of how many times 0 thru 9 appears in a chart, could you please post it here?

             

            Thanks in advance

            L ttaL   T

              johnph77's avatar - avatar
              CA
              United States
              Member #2987
              December 10, 2003
              832 Posts
              Offline
              Posted: February 10, 2005, 1:16 am - IP Logged

              try the functions available with "=FREQUENCY"

              gl

              j

              Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

              Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

               =^.^=

                SirMetro's avatar - center
                East of Atlanta
                United States
                Member #6191
                August 11, 2004
                1389 Posts
                Offline
                Posted: February 10, 2005, 1:03 pm - IP Logged

                I use the formula below to count how many times a number occurs on a given day

                =SUMPRODUCT(--(Cash3History!A2:A141=V38),--(Cash3History!D2:D141=U39))

                A2:A141 contains a reference to day of the week (Sun thru Sat)

                V38 contains the day I am currently interested in (Sun thru Sat)

                D2:D141 contains the numbers I am looking at (single position)

                U39 contains a reference to the number I am looking for.

                =========================================================

                Also, you could use the following formula if you are only counting individual numbers with no regard to what day of the week:

                =COUNTIF(Cash3History!D2:D4500,U4)

                D2:D4500 contains the number (single position with this example)

                U4 contains the number in the chart I am interested in.

                Sir Metro

                  Avatar
                  Poway CA (San Diego County)
                  United States
                  Member #3489
                  January 25, 2004
                  14120 Posts
                  Offline
                  Posted: February 10, 2005, 1:10 pm - IP Logged

                  I'm looking for a formula that will give me the winning number of the next draw (straight).  PLEASE!!!  LOL

                  Thanks to all that took the time to answer the questions about formulas. 

                    SirMetro's avatar - center
                    East of Atlanta
                    United States
                    Member #6191
                    August 11, 2004
                    1389 Posts
                    Offline
                    Posted: February 10, 2005, 1:29 pm - IP Logged

                    Formula I use for each and every winning number produced by all lotteries,

                    Take all the cash I had intended to spend on the lotteries to the local liquor store, find the biggest bottle of crown royal select that the money in my hand can buy and pocket the change. Go home, pour myself a (ok a glass full) in my nice monogramed crown royal cup, kick back and day dream of what it would be like to actually win big while that nice alcoholic buzz sets in.

                    I win every time that way ;-)

                    Sir Metro

                    One's viewpoint of life is all that matters in the end.

                      lottaloot's avatar - AvatarZ56
                      Redford/MI
                      United States
                      Member #3396
                      January 18, 2004
                      4867 Posts
                      Offline
                      Posted: February 10, 2005, 2:39 pm - IP Logged

                      Thanks

                      L ttaL   T

                        lottaloot's avatar - AvatarZ56
                        Redford/MI
                        United States
                        Member #3396
                        January 18, 2004
                        4867 Posts
                        Offline
                        Posted: February 10, 2005, 2:43 pm - IP Logged
                        Quote: Originally posted by SirMetro on February 10, 2005



                        Formula I use for each and every winning number produced by all lotteries,

                        Take all the cash I had intended to spend on the lotteries to the local liquor store, find the biggest bottle of crown royal select that the money in my hand can buy and pocket the change. Go home, pour myself a (ok a glass full) in my nice monogramed crown royal cup, kick back and day dream of what it would be like to actually win big while that nice alcoholic buzz sets in.

                        I win every time that way ;-)

                        Sir Metro

                        One's viewpoint of life is all that matters in the end.




                        Too funny!!!!!

                        L ttaL   T

                          Littleoldlady's avatar - basket
                          Clarksville
                          United States
                          Member #487
                          July 15, 2002
                          17638 Posts
                          Offline
                          Posted: February 13, 2005, 8:49 am - IP Logged

                          My question has 3 parts....

                          part 1:  How can I use excel to find all three digits that fell behind a particular number..? (pick 3)

                          part 2:  how do I set up a database in excel? (I'm still using 98)

                          part 3:  Is there anyway to highlight the numbers so I can see them?

                          If you know your number is going to hit, have patience and then KILL IT!

                          You never know when you will get another hit.