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

Pick 3 excel formula

Topic closed. 7 replies. Last post 6 months ago by Raven62.

Page 1 of 1
PrintE-mailLink
adulane62's avatar - file php?avatar=16228.gif
From Denver, Rocky Mountain Empire,
United States
Member #49750
February 13, 2007
439 Posts
Offline
Posted: June 1, 2016, 3:36 am - IP Logged

Anyone know the whole 1000 Pick 3 excel formula for singles, doubles, and triples...don't wanna put 'em one at a time! Thanks!

Go Broncos!  White Bounce

    Avatar

    United States
    Member #41846
    June 23, 2006
    458 Posts
    Offline
    Posted: June 1, 2016, 5:11 am - IP Logged

    in cell a1    0

    in cell a2    =a1+1

    copy a2 down as needed

     

    If this is not what you wanted, please explain

      adulane62's avatar - file php?avatar=16228.gif
      From Denver, Rocky Mountain Empire,
      United States
      Member #49750
      February 13, 2007
      439 Posts
      Offline
      Posted: June 1, 2016, 5:39 am - IP Logged

      phileight, 

      Thanks for your help! However, that is not what I'm looking for...I have downloaded all 1000 numbers, I just need a formula that shows singles as "S", doubles as "D", etc...Thanks.

      Go Broncos!  White Bounce

        CARBOB's avatar - FL LOTTERY_LOGO.png
        ORLANDO, FLORIDA
        United States
        Member #4924
        June 3, 2004
        5893 Posts
        Offline
        Posted: June 1, 2016, 5:43 am - IP Logged

        Anyone know the whole 1000 Pick 3 excel formula for singles, doubles, and triples...don't wanna put 'em one at a time! Thanks!

        All 3 digits must be in one cell.

         

        SHIFT-CTRL-ENTER

        =IF(OR(AND(ISNUMBER(MATCH({0,1,9},MID($K680,{1,2,3},1)+0,0))),AND(ISNUMBER(MATCH(MIN(MID($K680,{1,2,3},1)+0)+{0,1,2},MID($K680,{1,2,3},1)+0,0)))),"C",INDEX({"S","D","T"},MAX(FREQUENCY(MID($K680,{1,2,3},1)+0,MID($K680,{1,2,3},1)+0))))

         

        Play 4 same way

        {1,2,3,4},1)+0)+{0,1,2,3},MID($V1,{1,2,3,4},1)+0,0)))),"C",IF(SUM(IF(FREQUENCY(MID($V1,{1,2,3,4},1)+0,MID($V1,{1,2,3,4},1)+0)=2,1))=2,"DD",INDEX({"S","D","T","Q"},MAX(FREQUENCY(MID($V1,{1,2,3,4},1)+0,MID($V1,{1,2,3,4},1)+0)))))

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: June 1, 2016, 5:46 am - IP Logged

          A1 = Pick 3 Number. Example 123

          B1 = Value(mid(text($A1,"000"),1,1))

          C1 = Value(mid(text($A1,"000"),2,1))

          D1 = Value(mid(text($A1,"000"),3,1))

           

          Cell E1 enter the following formula:

          =CHOOSE(MAX(INDEX(COUNTIF($B1:$D1,$B1:$D1),)),"S","D","T"))

            adulane62's avatar - file php?avatar=16228.gif
            From Denver, Rocky Mountain Empire,
            United States
            Member #49750
            February 13, 2007
            439 Posts
            Offline
            Posted: June 1, 2016, 6:07 am - IP Logged

            Works like a charm! Thank you carbob and winsum! and phileight too!

            Go Broncos!  White Bounce

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: June 1, 2016, 6:59 am - IP Logged

              Boxed Formula using lowform_3 function.

              Google Excel VBA functions

              Enter your Pick 3 number in cell A1

              Enter the following formula in cell F1

              =lowform_3(A1)

              This will give you the "box" set from cell A1

              You will need to know how to add this code below to a new module before using it.

              Not sure who posted the code below here at LP.  Not mine.

              Function lowform_3(three_digit)
                    Dim channel() As Integer
                    Dim slot() As Integer
                    Dim num As Integer, pos As Integer
                    Dim c0, c1, c2, c3
                   
                    c0 = three_digit
                    c1 = Int(c0 / 100)
                    c2 = Int((c0 Mod 100) / 10)
                    c3 = c0 Mod 10
                    ReDim channel(9)
                    ReDim slot(3)
                    channel(c1) = channel(c1) + 1
                    channel(c2) = channel(c2) + 1
                    channel(c3) = channel(c3) + 1
                    pos = 1
                    For num = 0 To 9
                        While channel(num) > 0
                          slot(pos) = num
                          channel(num) = channel(num) - 1
                          pos = pos + 1
                        Wend
                    Next num
                    lowform_3 = slot(1) * 100 + slot(2) * 10 + slot(3)
                  End Function

                Raven62's avatar - binary
                New Jersey
                United States
                Member #17843
                June 28, 2005
                49618 Posts
                Offline
                Posted: June 1, 2016, 8:09 am - IP Logged

                Anyone know the whole 1000 Pick 3 excel formula for singles, doubles, and triples...don't wanna put 'em one at a time! Thanks!

                https://www.lotterypost.com/charts/pick3/combinations

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