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

Any Jackpot Game

Topic closed. 972 replies. Last post 8 years ago by billybouy.

Page 57 of 65
PrintE-mailLink
Avatar
leesburg, fl
United States
Member #53062
June 22, 2007
596 Posts
Offline
Posted: May 1, 2009, 12:37 pm - IP Logged

the filters could be incorrect when coming in to EXCEL??

    Avatar

    United Kingdom
    Member #70630
    February 7, 2009
    734 Posts
    Offline
    Posted: May 1, 2009, 12:37 pm - IP Logged

    in column A what columns are you counting??  my count is W thru Z

    Thats the fault you will have to sort it, and then you will be OK.

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

      Avatar

      United Kingdom
      Member #70630
      February 7, 2009
      734 Posts
      Offline
      Posted: May 1, 2009, 12:39 pm - IP Logged

      the filters could be incorrect when coming in to EXCEL??

      Yes its different you can't use the same filter on Mac that you use on Microsoft.

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

        Avatar
        leesburg, fl
        United States
        Member #53062
        June 22, 2007
        596 Posts
        Offline
        Posted: May 1, 2009, 12:42 pm - IP Logged

        can you give me the columns you count in A B C D E??

        The count for column B says =count(y3:AA3) and so forth. What is the correct formula for A B C D E???

          Avatar
          leesburg, fl
          United States
          Member #53062
          June 22, 2007
          596 Posts
          Offline
          Posted: May 1, 2009, 12:43 pm - IP Logged

          I see you are counting columns X thru AC. If you could give me the correct formulas I can change mine.

            Avatar
            leesburg, fl
            United States
            Member #53062
            June 22, 2007
            596 Posts
            Offline
            Posted: May 1, 2009, 12:48 pm - IP Logged

            the other formulas are correct. it seems to be A thry E??

              Avatar

              United Kingdom
              Member #70630
              February 7, 2009
              734 Posts
              Offline
              Posted: May 1, 2009, 12:53 pm - IP Logged

              I see you are counting columns X thru AC. If you could give me the correct formulas I can change mine.

              Start at X and do a count of 3 columns," do you know how to do it" then go to Y and so on, get the idea it's simple but it works better than all the formulas I have tried. You insert a function the drop down list comes down and you select COUNT.

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

                Avatar

                United Kingdom
                Member #70630
                February 7, 2009
                734 Posts
                Offline
                Posted: May 1, 2009, 1:01 pm - IP Logged

                turtle when you are sorted use 0 in E and use 1 in C and D and mark them 2 forget the others, then use 1 in E and 0 in C and D and forget the others mark them with 1, 1 should be spaces and 2 should be numbers you want spaces as you will have six in there.

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

                  Avatar
                  leesburg, fl
                  United States
                  Member #53062
                  June 22, 2007
                  596 Posts
                  Offline
                  Posted: May 1, 2009, 1:04 pm - IP Logged

                  yes, i have A - X thru Z   B - Y thru AA  C- Z thru AB   D - AA thru AC.

                  what is your formula for E??? It is showing X thru AB. is that correct???

                    Avatar
                    leesburg, fl
                    United States
                    Member #53062
                    June 22, 2007
                    596 Posts
                    Offline
                    Posted: May 1, 2009, 1:06 pm - IP Logged

                    are you marking them in col W???

                      Avatar
                      leesburg, fl
                      United States
                      Member #53062
                      June 22, 2007
                      596 Posts
                      Offline
                      Posted: May 1, 2009, 1:09 pm - IP Logged

                      my formula in col E is not right. what columns are you counting????

                        Avatar

                        United Kingdom
                        Member #70630
                        February 7, 2009
                        734 Posts
                        Offline
                        Posted: May 1, 2009, 1:26 pm - IP Logged

                        my formula in col E is not right. what columns are you counting????

                        E AB2:AD2.

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

                          Avatar

                          United Kingdom
                          Member #70630
                          February 7, 2009
                          734 Posts
                          Offline
                          Posted: May 1, 2009, 1:30 pm - IP Logged

                          are you marking them in col W???

                          Yes and I have inserted the new column ready for sat so the E is reading that as well. OK. are you winning.

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

                            Avatar

                            United Kingdom
                            Member #70630
                            February 7, 2009
                            734 Posts
                            Offline
                            Posted: May 1, 2009, 1:32 pm - IP Logged

                             its tea time turtle later.

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

                              x1kosmic's avatar - neptune vg2.gif

                              United States
                              Member #48046
                              December 7, 2006
                              1699 Posts
                              Offline
                              Posted: May 1, 2009, 1:34 pm - IP Logged

                                Sorry to disturb, have you up-dated your Main Chart at your blog from Wed?

                                      I like looking at it,    .... the Blue section looks 3-D   Thumbs Up

                                 
                                Page 57 of 65