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

another excel question

Topic closed. 23 replies. Last post 1 year ago by lakerben.

Page 2 of 2
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
Posted: June 27, 2015, 1:16 am - IP Logged
    Avatar

    United States
    Member #41846
    June 23, 2006
    460 Posts
    Offline
    Posted: June 27, 2015, 6:39 am - IP Logged

    Works great now.  The instructions are good. I hope they are permanent instructions in case I forget. Is the color code on the right changeable?  Is it programmed to show multiple hits?  If not that cool it is what I needed as far as the program!!  Nice job!

     

    Lurking

    the instructions will disappear when you run the program.  fairly simple once you know what's going on . you could always download another version and not run it.

     color code can be changed.  if you have desired colors advise.

    multiple hits?  the colors indicate the number of times a boxed pair has hit within the number of games selected. if you mean something else let me know

      lakerben's avatar - spherewall
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11120 Posts
      Offline
      Posted: June 27, 2015, 11:56 am - IP Logged

      the instructions will disappear when you run the program.  fairly simple once you know what's going on . you could always download another version and not run it.

       color code can be changed.  if you have desired colors advise.

      multiple hits?  the colors indicate the number of times a boxed pair has hit within the number of games selected. if you mean something else let me know

      Thanks, I appreciate everything.

      Lurking

      How about them cowboys!

       

       

      US Flag

        lakerben's avatar - spherewall
        New Mexico
        United States
        Member #86099
        January 29, 2010
        11120 Posts
        Offline
        Posted: June 27, 2015, 1:51 pm - IP Logged

        Thanks steve!

        How about them cowboys!

         

         

        US Flag

          Avatar

          United States
          Member #41846
          June 23, 2006
          460 Posts
          Offline
          Posted: June 27, 2015, 2:14 pm - IP Logged

          options added for combining games. 

          option to display instructions . they mostly go away once you start looking at data.  click on the instruction button and they are back

          finished all pairs for a pick 4 game

          added option on data tab to insert new line for data

           

           

           

          https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

            lakerben's avatar - spherewall
            New Mexico
            United States
            Member #86099
            January 29, 2010
            11120 Posts
            Offline
            Posted: June 27, 2015, 4:31 pm - IP Logged

            options added for combining games. 

            option to display instructions . they mostly go away once you start looking at data.  click on the instruction button and they are back

            finished all pairs for a pick 4 game

            added option on data tab to insert new line for data

             

             

             

            https://www.dropbox.com/s/4spbxm271cozsif/laker_ben.xls?dl=0

            Thanks for all your hard work.

             

            Drum

            How about them cowboys!

             

             

            US Flag

              lakerben's avatar - spherewall
              New Mexico
              United States
              Member #86099
              January 29, 2010
              11120 Posts
              Offline
              Posted: July 22, 2015, 1:44 pm - IP Logged

              Thumbs Up

              How about them cowboys!

               

               

              US Flag

                Avatar
                Lincoln, California
                United States
                Member #167130
                June 27, 2015
                256 Posts
                Offline
                Posted: August 10, 2015, 10:31 pm - IP Logged

                I know I am late to the party but here is what I do.  Use Conditional formatting with a with this Formula in the formula box  =IF(COUNTIF($A$1:$C$1,T1)>0,1,) ($A$1:$C$1 ARE THE CELLS OF THE GAME TO BE CHECKED) make sure that it is locked $$, T1 is the cell that you are formatting make sure that it is unlockedevaluating in the box is not locked.

                  lakerben's avatar - spherewall
                  New Mexico
                  United States
                  Member #86099
                  January 29, 2010
                  11120 Posts
                  Offline
                  Posted: August 11, 2015, 12:44 am - IP Logged

                  I know I am late to the party but here is what I do.  Use Conditional formatting with a with this Formula in the formula box  =IF(COUNTIF($A$1:$C$1,T1)>0,1,) ($A$1:$C$1 ARE THE CELLS OF THE GAME TO BE CHECKED) make sure that it is locked $$, T1 is the cell that you are formatting make sure that it is unlockedevaluating in the box is not locked.

                  Thanks allen and welcome.  Good luck in your game.  If you have time program this for yourself and others if you wish.

                  How about them cowboys!

                   

                   

                  US Flag