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

excel Help Needed

Topic closed. 9 replies. Last post 11 years ago by lottaloot.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: November 11, 2005, 10:15 pm - IP Logged

Trying to come up with a formula that will count the max out of a pair

Someone gave me this formula but it doesn't seem to work for me. 

=IF(COUNT($H:$M)=("pair"),1,"")

 

L ttaL   T

    hypersoniq's avatar - 8ball
    Pennsylvania
    United States
    Member #1340
    April 6, 2003
    2450 Posts
    Offline
    Posted: November 11, 2005, 10:44 pm - IP Logged

    that formula seems like part of a much more complex sheet.

    I don't recognise "pair", that might have been a few pre-filtering columns that identified pairs with the word "pair"...

    Playing more than one ticket per game is betting against yourself.

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: November 11, 2005, 10:52 pm - IP Logged

      Actually I typed in the word "pair"

      33 was the pair that I was in search of.

      =IF(COUNT($H:$M)=33,1,"")

      I could type in any pair that I happen to be searching for. 

      L ttaL   T

        cahaba's avatar - moon
        Birmingham
        United States
        Member #18850
        July 21, 2005
        82 Posts
        Offline
        Posted: November 11, 2005, 10:55 pm - IP Logged

        You may have too many quotation marks

        "Life is like a box of chocolates...you can speculate on what you're going to get through trial and error"




          lottaloot's avatar - AvatarZ56
          Redford/MI
          United States
          Member #3396
          January 18, 2004
          4867 Posts
          Offline
          Posted: November 11, 2005, 11:01 pm - IP Logged

          Nope, that's not it.



          The quotation marks return a blank cell.



          Trying to develop this for the OK spreadsheet--since it is just taking off.


          and would like to incorporate it into my all states spreadsheet.

          L ttaL   T

            Thoth's avatar - binary
            Findlay, Ohio
            United States
            Member #4855
            May 28, 2004
            400 Posts
            Offline
            Posted: November 12, 2005, 12:27 am - IP Logged

            Lottaloot,

            Do you want a spreadsheet that tracks all the pairs in each position (front-back-split) and how far they are currently out, or do you want to see a list of the skips and hits for each pair?

            ~Probability=Odds in Motion~

              lottaloot's avatar - AvatarZ56
              Redford/MI
              United States
              Member #3396
              January 18, 2004
              4867 Posts
              Offline
              Posted: November 12, 2005, 6:09 am - IP Logged

              Lottaloot,

              Do you want a spreadsheet that tracks all the pairs in each position (front-back-split) and how far they are currently out, or do you want to see a list of the skips and hits for each pair?

               

              I want to see an idividual list of far many skips & hits for each pair (each time they hit) 

               

              Hard to explain it...

              The sheet already gives me the skips of a pair & I can see how many times it has hit as well. 

              Like Versabet does

              I want it to give me the max out & average out of the pairs

              L ttaL   T

                JKING's avatar - Kaleidoscope 3.gif

                United States
                Member #5599
                July 13, 2004
                1192 Posts
                Offline
                Posted: November 12, 2005, 8:27 am - IP Logged

                Try this link:

                http://www.mrexcel.com/board2/index.php

                It doesn't answer your question, but, sends you to a really good source for the solution.

                You are a slave to the choices you have made.  jk

                Even a blind squirrel will occasioanlly find an acorn.

                  Thoth's avatar - binary
                  Findlay, Ohio
                  United States
                  Member #4855
                  May 28, 2004
                  400 Posts
                  Offline
                  Posted: November 12, 2005, 2:38 pm - IP Logged

                  Lottaloot,

                  Do you want a spreadsheet that tracks all the pairs in each position (front-back-split) and how far they are currently out, or do you want to see a list of the skips and hits for each pair?

                   

                  I want to see an idividual list of far many skips & hits for each pair (each time they hit) 

                   

                  Hard to explain it...

                  The sheet already gives me the skips of a pair & I can see how many times it has hit as well. 

                  Like Versabet does

                  I want it to give me the max out & average out of the pairs

                  I think you should try using the Database Functions....DMAX, DCOUNT, DAVERAGE.

                  I have an Excel workbook that uses them to display the total hits, largest skip (max out), averages and other info for each pair by position (front,back, and split).  It is a bit tricky to update though. 

                  If you care to send me your states history in Excel format I will update it for you and send you the workbook file.

                  integraGSR18L@aol.com

                  Scott

                  ~Probability=Odds in Motion~

                    lottaloot's avatar - AvatarZ56
                    Redford/MI
                    United States
                    Member #3396
                    January 18, 2004
                    4867 Posts
                    Offline
                    Posted: November 12, 2005, 4:18 pm - IP Logged

                    Thanks. 

                    I will try & send it to you tonight. 

                     

                    L ttaL   T