Welcome Guest
Log In | Register )
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
PrintE-mailLink
lottaloot's avatar - AvatarZ56
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

    lottaloot's avatar - AvatarZ56
    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

      txp3maven's avatar - Lottery-031.jpg
      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!!!

       

        http://www.techonthenet.com/excel/macros/pairs.php

       

      txp3m

        lottaloot's avatar - AvatarZ56
        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