Welcome Guest
Log In | Register )
You last visited December 3, 2016, 10:44 am
All times shown are
Eastern Time (GMT-5:00)

Needed: Excel Formula!

Topic closed. 4 replies. Last post 11 years ago by scott_one.

Page 1 of 1
PrintE-mailLink
scott_one's avatar - abstract
Lapeer, MI
United States
Member #9977
December 29, 2004
31 Posts
Offline
Posted: July 13, 2005, 5:20 pm - IP Logged

Hello,
I have been following the post here regularly and have found members to be very helpful and I was hoping someone could help me out with a formula in excel.

I would like to know of a formula for tracking numbers drawn with other numbers in a Fantasy 5 game. Ex. how many times 5 was drawn with 21 etc.

Column A is the date of draw and column B thru F are the 5 numbers drawn.

Any help would be greatly appreciated.

Thank you in advance.

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Online
    Posted: July 14, 2005, 12:40 pm - IP Logged

    scott_one,

    Send me a PM with an email address and I will forward you the Excel worksheet with the Fantasy 5 past draws and the Pairs chart.

    wsls

     

      winsumloosesum's avatar - Lottery-060.jpg
      Pennsylvania
      United States
      Member #2218
      September 1, 2003
      5387 Posts
      Online
      Posted: July 14, 2005, 10:08 pm - IP Logged

      Those interested in tracking Pairs uisng Excel.

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

       

      You can adjust the number of digits drawn in your lottery.

      If you use a large range of past draws you need to adjust the code.

      Good Luck!!

      wsls 

       

       

        SirMetro's avatar - center
        East of Atlanta
        United States
        Member #6191
        August 11, 2004
        1389 Posts
        Offline
        Posted: July 15, 2005, 7:42 am - IP Logged

        You might want to consider this formula...I use it to track how many times a number for a given day of the week has occurred. I am sure it can be adjusted as you need it to check to see when a number has occurred with another number. Of course, I am sure there are better ways to check as well.

        SUMPRODUCT(--(Cash4History!$A$2:$A$141=$AN$2),--(Cash4History!$D$2:$D$141=$AM3))


        Breakdown of the formula

        SUMPRODUCT(--(Cash4History!$A$2:$A$141 <--Range holding the Day of week

        =$AN$2) <--Day match to check for

        ,--(Cash4History!$D$2:$D$141 <--Range holding the numbers being searched

        =$AM3)) <--Number Match to check for

          scott_one's avatar - abstract
          Lapeer, MI
          United States
          Member #9977
          December 29, 2004
          31 Posts
          Offline
          Posted: July 16, 2005, 5:45 pm - IP Logged

          Thanks for the replys. That link was just what I was looking for.