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

Need Excel help ... fast and quick!

Topic closed. 10 replies. Last post 6 years ago by ecosvaldo.

Page 1 of 1
PrintE-mailLink
Avatar
New Member

United States
Member #104099
January 9, 2011
9 Posts
Offline
Posted: February 25, 2011, 12:58 pm - IP Logged

I purchased Gail Howard's Lottery Master Guide over a month ago and have been reading it non-stop. Since I found out that her Lottery Advantage software is not compatible with the 64-bit version of Windows 7 Home Premium, I took it upon myself to recreate her charts myself in Excel. Having almost completed my Excel file (I have about 6 sheets total), I've come across a problem that needs solving. And instead of just asking, I decided to use screenshots and show you what I'm looking for:

 

ST Lotto

MT Lotto

Can anybody help me?

    Tenaj's avatar - michellea
    Charlotte NC
    United States
    Member #17406
    June 18, 2005
    4054 Posts
    Offline
    Posted: February 25, 2011, 1:01 pm - IP Logged

    I purchased Gail Howard's Lottery Master Guide over a month ago and have been reading it non-stop. Since I found out that her Lottery Advantage software is not compatible with the 64-bit version of Windows 7 Home Premium, I took it upon myself to recreate her charts myself in Excel. Having almost completed my Excel file (I have about 6 sheets total), I've come across a problem that needs solving. And instead of just asking, I decided to use screenshots and show you what I'm looking for:

     

    ST Lotto

    MT Lotto

    Can anybody help me?

    What?Return it and get the version that you need.

    takeemtothebank

      Avatar
      New Member

      United States
      Member #104099
      January 9, 2011
      9 Posts
      Offline
      Posted: February 25, 2011, 1:04 pm - IP Logged

      Huh??

        Tenaj's avatar - michellea
        Charlotte NC
        United States
        Member #17406
        June 18, 2005
        4054 Posts
        Offline
        Posted: February 25, 2011, 1:09 pm - IP Logged

        Huh??

        Send Gail Howard's software back and get the version you need.

        takeemtothebank

          Avatar
          New Member

          United States
          Member #104099
          January 9, 2011
          9 Posts
          Offline
          Posted: February 25, 2011, 1:17 pm - IP Logged

          Send Gail Howard's software back and get the version you need.

          Oh, no I don't have her software.

          I explained that my 64-bit version of Windows 7 Home Premium is not compatible with her software, so I recreated her charts in Excel. In my file, when I load a list of past winning numbers, the file will automatically calculate the necessary information I need (like how many odd/even number balls show up in each drawing, automatically generate a Drawings Since Hit chart for Medium Lotto Trends, etc.)

          So this is an Excel question/problem that I need help solving.

            Avatar
            New Member

            United States
            Member #104099
            January 9, 2011
            9 Posts
            Offline
            Posted: February 26, 2011, 6:22 am - IP Logged

            Can anyone help me?

              Avatar
              New Member

              United States
              Member #104099
              January 9, 2011
              9 Posts
              Offline
              Posted: February 26, 2011, 5:41 pm - IP Logged

              No one?

                Avatar

                United States
                Member #105312
                January 29, 2011
                435 Posts
                Offline
                Posted: February 26, 2011, 6:00 pm - IP Logged

                Sorry ecosvaldo.  I put your problem up on Excel 2007 and worked an hour trying to get it to do what you're tryig to do.  No luck here.  I'm not sure Excel can do it.

                Good luck.

                  garyo1954's avatar - garyo
                  Dallas, Texas
                  United States
                  Member #4549
                  May 2, 2004
                  1834 Posts
                  Offline
                  Posted: February 26, 2011, 6:22 pm - IP Logged

                  If you go to the "HOME" tab you will see a category for "FORMULAS" (right after "PAGE LAYOUT and before "DATA.") Under that heading there is many categories. Text, financial, logical, date and time, lookup, math and trig, etc. Click them. Just go down the lists. You'll learn something.

                  Or try an Excel site. 

                  Maybe ask Gail Howard.

                    winsumloosesum's avatar - Lottery-060.jpg
                    Pennsylvania
                    United States
                    Member #2218
                    September 1, 2003
                    5396 Posts
                    Offline
                    Posted: February 26, 2011, 6:37 pm - IP Logged

                    I purchased Gail Howard's Lottery Master Guide over a month ago and have been reading it non-stop. Since I found out that her Lottery Advantage software is not compatible with the 64-bit version of Windows 7 Home Premium, I took it upon myself to recreate her charts myself in Excel. Having almost completed my Excel file (I have about 6 sheets total), I've come across a problem that needs solving. And instead of just asking, I decided to use screenshots and show you what I'm looking for:

                     

                    ST Lotto

                    MT Lotto

                    Can anybody help me?

                    ecosvaldo,

                    Question 1:  What lottery game are you using?

                    Question 2: What does the "xx" represent?  Is this a skip/hit chart of some sort?

                    PM me and I might be able to help you.

                      Avatar
                      New Member

                      United States
                      Member #104099
                      January 9, 2011
                      9 Posts
                      Offline
                      Posted: February 26, 2011, 7:00 pm - IP Logged

                      Hi winsumloosesum. I sent you a PM.