Welcome Guest
Log In | Register )
You last visited May 22, 2017, 7:05 pm
All times shown are
Eastern Time (GMT-5:00)

Mega Millions

Topic closed. 22 replies. Last post 5 years ago by adulane62.

Page 2 of 2
32
PrintE-mailLink
SergeM's avatar - slow icon.png
Economy class
Belgium
Member #123700
February 27, 2012
4035 Posts
Offline
Posted: August 8, 2012, 10:42 am - IP Logged

man..I must be dense. What do you mean filter A,B,C. How do you filter? 3 filters per group? etc. etc, I am totally lost

I tell you what it is.

  • Sheet 2 is basically skip-chart, which doesn't work by itself. There is no formula and no code.
  • Sheet 2 is incomprehensive as correct headers are missing. There are no guidelines.
  • The use of the sheet isn't defined to get to a selection.

Sheet 1 contains drawing information. There is no connection to sheet 2. The information is in one column and formulas don't work on this.

The creator of the workbook is unknown. There are formulas missing.

    lakerben's avatar - Trek Galaxy2.gif
    New Mexico
    United States
    Member #86099
    January 29, 2010
    11398 Posts
    Offline
    Posted: August 8, 2012, 2:16 pm - IP Logged

    Hi flossdog, go to the first group at the start of the sheet, then filter A, then filter B, then filter C, that will give you the three filters, from your first selection in A, continue to the second A, and filter the same  to that one, B, C, then do the the third A, and continue, the A,B,C. from the first group pair with the A,B,C. from the second group, and the answer is in there, you can also go to the end and filter 1 from the first group and pair with 1 from the second group.

    Everything on the sheet works together no matter what you filter.

    If you are still having problems, wait for turtle0747, to come on site, he speaks American...he knows what to do.

    Regards,

    billybouy...

    I speak American most of the time.  Wouldn't it be easier to just re-program this to filter all at once and show a list of the picks??

      Avatar
      Thread Starter

      United Kingdom
      Member #70630
      February 7, 2009
      734 Posts
      Offline
      Posted: August 8, 2012, 2:29 pm - IP Logged

      I speak American most of the time.  Wouldn't it be easier to just re-program this to filter all at once and show a list of the picks??

      Hi lakerben,

      You are probably right, but then I am no good with code, so until I am ready it stays the way it is unfortunately.

      Regards,

      billybouy...

      Sometimes we can't see the woods for tree's, " so we have to clear a path "

        Avatar
        Thread Starter

        United Kingdom
        Member #70630
        February 7, 2009
        734 Posts
        Offline
        Posted: August 9, 2012, 2:47 am - IP Logged

        The Mega sheet is updated.

        Regards,

        billybouy...

        https://www.box.com/s/cd70da1f5474f7f34f98

        Sometimes we can't see the woods for tree's, " so we have to clear a path "


          United States
          Member #97695
          September 21, 2010
          358 Posts
          Offline
          Posted: August 10, 2012, 1:10 am - IP Logged

          The Mega sheet is updated.

          Regards,

          billybouy...

          https://www.box.com/s/cd70da1f5474f7f34f98

          How much money have you won with your sheet and filter?

            Avatar
            Thread Starter

            United Kingdom
            Member #70630
            February 7, 2009
            734 Posts
            Offline
            Posted: August 10, 2012, 8:19 am - IP Logged

            How much money have you won with your sheet and filter?

            Hi Blowhard,

            I don't gamble, all I can tell you is it is consistent with repetitive routines.

            Hope this helps.

            Regards,

            billybouy...

            Sometimes we can't see the woods for tree's, " so we have to clear a path "

              Avatar
              Thread Starter

              United Kingdom
              Member #70630
              February 7, 2009
              734 Posts
              Offline
              Posted: August 12, 2012, 7:07 am - IP Logged

              Hi every one, here is where they came on Fri, highlights at the top of the columns indicate the filters.

              Regards,

              billybouy...

              https://www.box.com/s/cd70da1f5474f7f34f98

              Sometimes we can't see the woods for tree's, " so we have to clear a path "

                adulane62's avatar - file php?avatar=16228.gif
                From Denver, Rocky Mountain Empire,
                United States
                Member #49750
                February 13, 2007
                500 Posts
                Offline
                Posted: August 12, 2012, 3:23 pm - IP Logged

                Hi every one, here is where they came on Fri, highlights at the top of the columns indicate the filters.

                Regards,

                billybouy...

                https://www.box.com/s/cd70da1f5474f7f34f98

                Your tag line says it all. unfortunately, the "path you are trying to clear" leads to nowhere! A newbie to excel, perhaps? Would you be so kind to post a video on youtube to explain this idiotic nonsense? Thanx.