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

Pick 4 excel help please

Topic closed. 12 replies. Last post 4 years ago by jstewart26.

Page 1 of 1
51
PrintE-mailLink
Mickie's avatar - Lottery-008.jpg
Spring Lake
United States
Member #313
April 26, 2002
181 Posts
Offline
Posted: February 23, 2013, 8:30 am - IP Logged

I have a number 1845

I would like if anyone has a formula to make this boxed (1458)

I have been using the morefunc & it works great but when
I go to other machines that doesn't have the morefunc on them it doesn't
come up.

 

Here is the pick 3 formula if anyone is interested:

=CONCATENATE((MIN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MEDIAN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MAX(LEFT(I2),
MID(I2,2,1),RIGHT(I2)))))

Replace the I2 for the cell of your choice :-)

 

Thanks bunches

MickieDisney

    SergeM's avatar - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 Posts
    Offline
    Posted: February 23, 2013, 2:46 pm - IP Logged

    I have a number 1845

    I would like if anyone has a formula to make this boxed (1458)

    I have been using the morefunc & it works great but when
    I go to other machines that doesn't have the morefunc on them it doesn't
    come up.

     

    Here is the pick 3 formula if anyone is interested:

    =CONCATENATE((MIN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MEDIAN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MAX(LEFT(I2),
    MID(I2,2,1),RIGHT(I2)))))

    Replace the I2 for the cell of your choice :-)

     

    Thanks bunches

    There were many posts solving this problem without coding VBA.
    Your solution is not okay.


      United States
      Member #133964
      October 14, 2012
      167 Posts
      Offline
      Posted: February 23, 2013, 4:33 pm - IP Logged

      help on wis lottery 4 for tonight   numbers last night 6089   tonight numbers to play???????????????????????

        Mickie's avatar - Lottery-008.jpg
        Spring Lake
        United States
        Member #313
        April 26, 2002
        181 Posts
        Offline
        Posted: February 23, 2013, 5:42 pm - IP Logged

        Sorry I really don't have any systems just yet. Just looking for a formula to make a Pick 4 number boxed.

        The formula I posted is for a Pick 3 number boxed. 

         

        Good Luck

        MickieDisney

          ranman17's avatar - jzy6nr
          New York
          United States
          Member #83026
          November 27, 2009
          2132 Posts
          Offline
          Posted: February 23, 2013, 6:09 pm - IP Logged

          I have a number 1845

          I would like if anyone has a formula to make this boxed (1458)

          I have been using the morefunc & it works great but when
          I go to other machines that doesn't have the morefunc on them it doesn't
          come up.

           

          Here is the pick 3 formula if anyone is interested:

          =CONCATENATE((MIN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MEDIAN(LEFT(I2),MID(I2,2,1),RIGHT(I2))),(MAX(LEFT(I2),
          MID(I2,2,1),RIGHT(I2)))))

          Replace the I2 for the cell of your choice :-)

           

          Thanks bunches

          Are you looking for a way to put your 1845 in and have excel or a website show every permutation of that number?

          Be kind, because everyone you meet is fighting a great battle.

          An Unruly Evil

            Mickie's avatar - Lottery-008.jpg
            Spring Lake
            United States
            Member #313
            April 26, 2002
            181 Posts
            Offline
            Posted: February 23, 2013, 8:54 pm - IP Logged

            No, I am making a spreadsheet for the Pick 4 game like my Pick 3 spreadsheet. I took a picture, but can't insert here without posting to the net first.

            Across is the date, P1, P2, P3, Day, Pk3, Box, Cfg(u-d-t), Cfg(Dbls)x2 columns 1st is Fp/Bp/Oe, 2nd is the actual Dbl(33)
            Columns for the pairs, Vtracs, 3 columns for the Odd/Even cfgs, Sum, RtSum, Ldr.

            The formula I posted was for the box column next to Pk3. I got it here years ago.
            Now I am looking for a Pk 4 box formula. Winsumloosesum told me about the morefunc add on for excel that takes care of the boxing.
            Problem is that I can only use it on my computer. If I try to open my files on another computer the formulas don't work for the box column.
            I have never done alot with the Pk 4 but now I am looking into it again.

            Thank you.

            MickieDisney

              ranman17's avatar - jzy6nr
              New York
              United States
              Member #83026
              November 27, 2009
              2132 Posts
              Offline
              Posted: February 23, 2013, 9:40 pm - IP Logged

              No, I am making a spreadsheet for the Pick 4 game like my Pick 3 spreadsheet. I took a picture, but can't insert here without posting to the net first.

              Across is the date, P1, P2, P3, Day, Pk3, Box, Cfg(u-d-t), Cfg(Dbls)x2 columns 1st is Fp/Bp/Oe, 2nd is the actual Dbl(33)
              Columns for the pairs, Vtracs, 3 columns for the Odd/Even cfgs, Sum, RtSum, Ldr.

              The formula I posted was for the box column next to Pk3. I got it here years ago.
              Now I am looking for a Pk 4 box formula. Winsumloosesum told me about the morefunc add on for excel that takes care of the boxing.
              Problem is that I can only use it on my computer. If I try to open my files on another computer the formulas don't work for the box column.
              I have never done alot with the Pk 4 but now I am looking into it again.

              Thank you.

              There is a user here by the name of manual (look him up) he can probably put this on his site so that it can be used anywhere that you have an internet connection.  Here is his site: http://lottodrawodds.com/

              Be kind, because everyone you meet is fighting a great battle.

              An Unruly Evil

                Mickie's avatar - Lottery-008.jpg
                Spring Lake
                United States
                Member #313
                April 26, 2002
                181 Posts
                Offline
                Posted: February 23, 2013, 9:56 pm - IP Logged

                TY :-)

                MickieDisney

                  CARBOB's avatar - FL LOTTERY_LOGO.png
                  ORLANDO, FLORIDA
                  United States
                  Member #4924
                  June 3, 2004
                  5896 Posts
                  Online
                  Posted: February 24, 2013, 6:57 am - IP Logged

                  Ctrl-Shift-Enter

                  =SUMPRODUCT(SMALL(MID(BS17,ROW($BN$1:INDEX(BN:BN,LEN(BS17))),1)+0,ROW($BN$1:INDEX(BN:BN,LEN(BS17)))),10^(LEN(BS17)-ROW($BN$1:INDEX(BN:BN,LEN(BS17)))))

                  Change BS17 to the the cell that 1845 is in.

                    Mickie's avatar - Lottery-008.jpg
                    Spring Lake
                    United States
                    Member #313
                    April 26, 2002
                    181 Posts
                    Offline
                    Posted: February 24, 2013, 11:29 am - IP Logged

                    Thank you
                    Thank you
                    Thank you! Bunches :-)

                     

                    I have been learning all the time.I am starting to figure this all out.
                    What is the ROW($BN$1 used for? I don't have anything in that spot but was just wondering in case something should go there later.

                    MickieDisney

                      CARBOB's avatar - FL LOTTERY_LOGO.png
                      ORLANDO, FLORIDA
                      United States
                      Member #4924
                      June 3, 2004
                      5896 Posts
                      Online
                      Posted: February 25, 2013, 4:06 am - IP Logged

                      Thank you
                      Thank you
                      Thank you! Bunches :-)

                       

                      I have been learning all the time.I am starting to figure this all out.
                      What is the ROW($BN$1 used for? I don't have anything in that spot but was just wondering in case something should go there later.

                      That's my date column!

                        Mickie's avatar - Lottery-008.jpg
                        Spring Lake
                        United States
                        Member #313
                        April 26, 2002
                        181 Posts
                        Offline
                        Posted: February 25, 2013, 4:35 am - IP Logged

                        TY, I will change to my date column

                        Have a great day!

                        MickieDisney


                          United States
                          Member #133964
                          October 14, 2012
                          167 Posts
                          Offline
                          Posted: February 26, 2013, 12:28 pm - IP Logged

                          wis lottery  pick 4 last night 1121  key patterns says  to play numbers 1,8,5,7,3,8,0,2   ????? wat numbers should i play  0718 sound good for tonight ???