Welcome Guest
Log In | Register )
You last visited December 8, 2016, 1:03 pm
All times shown are
Eastern Time (GMT-5:00)

At a standstill until I can get

Topic closed. 6 replies. Last post 11 years ago by LAVERNE MALONEY.

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

this excel formula that I am working on.  I can not think about anything else. 

Trying to determine how to create a forumla that will tell me how many days it's been since a specific pair has been drawn. 

I am trying to encorporate that into my 7 states tracker. 

Will resume my 7 states posts when I'm too exhausted to think about the formula anymore or this phase has past

    LAVERNE MALONEY's avatar - smallgirl

    United States
    Member #1987
    August 5, 2003
    8968 Posts
    Offline
    Posted: June 29, 2005, 4:10 pm - IP Logged

    Hello there lottaloot, you will get the answer. When you are innovative you will eat, sleep & walk the very thing(s) that you are trying to achieve.

    When I took programming in college, I always wrote down the task in simple words first. Then I would apply it to the programming language.

     That sounds like a compare statement. Or a counting backwards from the present day's results. Or would you take the current day's results & compare it to the previous days results and add 1 or substract 1.

    I'm  hoping that this may spark an AH HA moment.

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

      Thanks Laverne.  I will take your advice & do just that. 

      Yes Nod

      You would think that I could just be happy with all the hurdles that I have overcome thus far...but I' m greedy for more ways to take the states money.  Hyper

        LAVERNE MALONEY's avatar - smallgirl

        United States
        Member #1987
        August 5, 2003
        8968 Posts
        Offline
        Posted: June 29, 2005, 4:28 pm - IP Logged
          lottaloot's avatar - AvatarZ56
          Redford/MI
          United States
          Member #3396
          January 18, 2004
          4867 Posts
          Offline
          Posted: June 29, 2005, 10:07 pm - IP Logged

          So far what I have come up with are listed below

          =MATCH(TRUE,MMULT(--(H2:M4=TEXT(O1,"@")),TRANSPOSE(COLUMN(H2:M4)*0+1))>0,0)-1
          or
          =MATCH(TRUE,COUNTIF(OFFSET(H2:M4,ROW(H2:M4)-MIN(ROW(H2:M4)),0,1),O1)>0,0)-1

          ...where O1 contains the number of interest, such as 36

          Of course, I did not write these formulas so I need a bit of help intrepreting them.

          Any volunteers????

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

            Well I think that I have the basics for finding out how many days out the pair is from the formula above. 

            I just have to make some adjustments to my spreadsheet & remember that it is a CSE formula.

            I do not like the fact that it starts the count with 0 (would like it to start with 1) but before I go fiddling around with it I will just have to deal. 

            Thanks everyone

            I feel better now. 

              LAVERNE MALONEY's avatar - smallgirl

              United States
              Member #1987
              August 5, 2003
              8968 Posts
              Offline
              Posted: June 30, 2005, 12:07 am - IP Logged

              Well I think that I have the basics for finding out how many days out the pair is from the formula above. 

              I just have to make some adjustments to my spreadsheet & remember that it is a CSE formula.

              I do not like the fact that it starts the count with 0 (would like it to start with 1) but before I go fiddling around with it I will just have to deal. 

              Thanks everyone

              I feel better now. 

              I'm glad you got some answers. Your statement about starting at zero. I know that in programming you have to initialize your counters to zero. You have to add 1 or subtract 1 to something.