Welcome Guest
You last visited December 9, 2016, 12:40 am
All times shown are
Eastern Time (GMT-5:00)

# Trying to figure out formula for

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

 Page 1 of 1
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 11, 2005, 6:54 am - IP Logged

actual hits of the pairs within my spreadsheet. I just was never any good at math.

I would like to calculate the actual pair hits & then determine the average amount of skips between hits.

I would like the pairs to be non-specific in their position (meaning I don't care about front or back pair hits for now)

I figure all I had to do was divide the lottery draws by the actual hits of the pairs; however, I have what I am sure is called an array formula for counting the skips of my pairs.

=MATCH(TRUE,MMULT(--(H\$1:M\$190=TEXT(BS2,"00")),TRANSPOSE(COLUMN(H\$1:M\$190)*0+1))>0,0)-1

I never even thought about a formula to count the actual hits (until now)

ANY HELP IS APPRECIATED

L ttaL   T

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 11, 2005, 7:18 am - IP Logged

I think I'm getting closer (thanks to whoever spoke on naming ranges in another thread)

I named my columns H:M where my pairs are (Pairs)

=COUNTIF(pairs,AN2)  To count the number of times the pairs are seen

Now do I simply divide by the draws to obtain the % that each pair hits?

L ttaL   T

New Member
DFW/Texas
United States
Member #10357
January 10, 2005
8 Posts
Offline
 Posted: December 11, 2005, 7:28 am - IP Logged

lottaloot,

See if this site helps you ... and thanks for all the posts, you truly are a numbers worst nightmare!!!

txp3m

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: December 11, 2005, 7:36 am - IP Logged

Thanks!!

L ttaL   T

 Page 1 of 1