Welcome Guest
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
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

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.

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

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.

United States
Member #1987
August 5, 2003
8968 Posts
Offline
 Posted: June 29, 2005, 4:28 pm - IP Logged
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????

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.

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.

 Page 1 of 1