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

Nice Pick-3 pair system

Topic closed. 89 replies. Last post 4 years ago by tonyg.

Page 4 of 6
4.36
PrintE-mailLink
Avatar
Florida
United States
Member #66575
October 30, 2008
3549 Posts
Offline
Posted: May 1, 2013, 10:01 pm - IP Logged

I have a formula for the higher lower subraction thing but can we alter to add the Lottery math part to it  lol

Array Formula

=MAX(D5:E5)-MIN(IF(D5:E5>0,D5:E5,""))

I havent really studied your sheet so Im just throwing stuff out there to consider  lol

If using helper cells you can use

to determine Highest or lowest and then just do your subraction

Regardless of order the left one always gives you the highest

=MAX(D6:E6)=MIN(D6:E6)

    ranman17's avatar - jzy6nr
    New York
    United States
    Member #83026
    November 27, 2009
    2132 Posts
    Offline
    Posted: May 1, 2013, 10:14 pm - IP Logged

    I have a formula for the higher lower subraction thing but can we alter to add the Lottery math part to it  lol

    Array Formula

    =MAX(D5:E5)-MIN(IF(D5:E5>0,D5:E5,""))

    I will see if I can figure out how to add the MOD to it but I have to go walk the dog so maybe later.

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

    An Unruly Evil


      United States
      Member #128790
      June 2, 2012
      5431 Posts
      Offline
      Posted: May 1, 2013, 11:07 pm - IP Logged

      I will see if I can figure out how to add the MOD to it but I have to go walk the dog so maybe later.

                                     Big Grin

       

        Avatar
        Florida
        United States
        Member #66575
        October 30, 2008
        3549 Posts
        Offline
        Posted: May 1, 2013, 11:43 pm - IP Logged

        Ranman  / OnlyMoney

        See if this is what you want

        https://www.box.com/s/699di6q6utlfv0hnx9ko

         

        PS: This is Ranmans sheet, I just made a small change

          helpmewin's avatar - dandy
          u$a
          United States
          Member #106665
          February 22, 2011
          19967 Posts
          Offline
          Posted: May 2, 2013, 12:13 am - IP Logged

          I will see if I can figure out how to add the MOD to it but I have to go walk the dog so maybe later.


            United States
            Member #128790
            June 2, 2012
            5431 Posts
            Offline
            Posted: May 2, 2013, 12:48 am - IP Logged

            Ranman  / OnlyMoney

            See if this is what you want

            https://www.box.com/s/699di6q6utlfv0hnx9ko

             

            PS: This is Ranmans sheet, I just made a small change

            I don't know what you did, but I have to commend you for this.

            Thumbs Up

             

            Both ranman17 and CarliG are the bomb !

              Avatar
              Florida
              United States
              Member #66575
              October 30, 2008
              3549 Posts
              Offline
              Posted: May 2, 2013, 12:50 am - IP Logged

              I don't know what you did, but I have to commend you for this.

              Thumbs Up

               

              Both ranman17 and CarliG are the bomb !

              Ranman did the hard part, I just gave it a minor tweak  ...

              Its not protected so make sure you dont wipe out the formulas  LOL

               

              CG

                lakerben's avatar - Lottery-061.jpg
                New Mexico
                United States
                Member #86099
                January 29, 2010
                11167 Posts
                Offline
                Posted: May 2, 2013, 12:58 am - IP Logged

                Ranman  / OnlyMoney

                See if this is what you want

                https://www.box.com/s/699di6q6utlfv0hnx9ko

                 

                PS: This is Ranmans sheet, I just made a small change

                Its not available.

                US Flag

                  helpmewin's avatar - dandy
                  u$a
                  United States
                  Member #106665
                  February 22, 2011
                  19967 Posts
                  Offline
                  Posted: May 2, 2013, 12:58 am - IP Logged

                  awesome job everyone they don't come here very fast but they did come Thumbs Upworks good

                   

                  Nice PEARS by the wayLOL

                    Avatar
                    Florida
                    United States
                    Member #66575
                    October 30, 2008
                    3549 Posts
                    Offline
                    Posted: May 2, 2013, 1:05 am - IP Logged

                    Its not available.

                    Seems to be okay now  CG

                    https://www.box.com/s/699di6q6utlfv0hnx9ko

                      lakerben's avatar - Lottery-061.jpg
                      New Mexico
                      United States
                      Member #86099
                      January 29, 2010
                      11167 Posts
                      Offline
                      Posted: May 2, 2013, 1:51 am - IP Logged

                      Thanks Carlig!

                       

                      Thumbs Up

                      US Flag

                        retxx's avatar - mrthumbs
                        BOSTON
                        United States
                        Member #48
                        September 9, 2001
                        3614 Posts
                        Offline
                        Posted: May 2, 2013, 10:23 am - IP Logged

                        Carlig you are the the greatest!!!!!!!
                        We request and you answer
                        Here is a parade for youParty

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

                          Onlymoney,

                           

                          Do me a favor and do you workout using 897 as the last drawn number.

                           

                          Thanks,

                          Ranman

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

                          An Unruly Evil


                            United States
                            Member #128790
                            June 2, 2012
                            5431 Posts
                            Offline
                            Posted: May 2, 2013, 9:25 pm - IP Logged

                            Onlymoney,

                             

                            Do me a favor and do you workout using 897 as the last drawn number.

                             

                            Thanks,

                            Ranman

                            897

                            9-7=2     9+7=16=7     last number 7

                             

                            Pairs: 27-27-77

                            I'll omit the dupe-27, but I'm aware It'll show up in the program twice.

                            Combos: 278-279-277

                                          778-779-777

                              DrMiracle's avatar - images q=tbn:ANd9GcSZfr3g-6xRNhDA2-tgWdb5fVaacJgb_ybXvQWgy-qL1s6p
                              MARYLAND
                              United States
                              Member #119884
                              December 5, 2011
                              1671 Posts
                              Offline
                              Posted: May 4, 2013, 1:39 am - IP Logged

                              Wow!!!! Great system...

                              Maryland 045 DAY MAY03...put into the system......result..950,954,955

                              BANG!!!! 957 EVE MAY 03

                               

                              193 MAY1 DAY..put into the system.....result..331,339,333

                              BANG!!! STRAIGHT HIT...331 MAY1 EVENING...

                              system worksBanana more money on the way..and tax freeNaughty