Welcome Guest
Log In | Register )
You last visited April 26, 2018, 5:28 am
All times shown are
Eastern Time (GMT-5:00)

Excel Help

Topic closed. 5 replies. Last post 12 years ago by winsumloosesum.

Page 1 of 1
United States
Member #4102
March 22, 2004
8 Posts
Posted: July 22, 2006, 9:20 am - IP Logged

OK, I'm always playing with numbers but I use pen/paper and get bored before I finish coping the numbers for my latest theory and give up.  Sometimes I use Excel for basics but I'm not knowledgeable about formulas.  Here is the latest formula I'm looking for:I want to compare the numbers drawn in the US on any given day for the Pick 5 games.  I copy/paste the results from LP in excel.  Example of one line:

State  Game  Draw Date  Results 
ArizonaFantasy 5Fri, Jul 21, 200602-03-08-09-20
I'm a visual person, so I would like to see some sort of check box for each drawn number, something like this:
State  Game  Draw Date  Results 12345678910
ArizonaFantasy 5Fri, Jul 21, 200602-03-08-09-20 XX    XX 
CaliforniaFantasy 5Fri, Jul 21, 200601-11-22-23-29X         
ColoradoCash 5Fri, Jul 21, 200605-20-22-31-32    X     
ConnecticutCash 5Fri, Jul 21, 200604-11-22-27-30   X      
FloridaFantasy 5Fri, Jul 21, 200606-07-11-18-29     XX   
So here is my question:  What formula would I use in a cell that would put an X (or any other value) if a number appeared in the Results field?  I have played with IF, COUNTIF, TRUE but can’t figure it out.  Is this even possible?Thanks in advance for any knowledge you can pass along! 
    LottoChica23's avatar - Aquarius
    Fughedaboutit (NY)
    United States
    Member #8160
    October 26, 2004
    6777 Posts
    Posted: July 22, 2006, 9:44 am - IP Logged

    You might want to do a search to see all of the excel hels threads on LP, there are a bunch of them. I think this thread http://www.lotterypost.com/thread/138053 may help you to do what you have described.

    Matrix Chart Instructions--> http://www.lotterypost.com/thread/191818 

    check out mysticwomyn Announcers --> http://www.lotterypost.com/thread/140695/673306

    You can judge the integrity of a man by the way he treats those that can do nothing for him...Thumbs Up

      New Mexico
      United States
      Member #12305
      March 10, 2005
      2984 Posts
      Posted: July 22, 2006, 11:12 am - IP Logged

      Cool thread.  I've seen repeated references to this subject.... hypersonic has done a great deal to try to help people understand the possibilities in the past.  You might track down his posts.

      I know people claim to be able to do such stuff.  But it's beyond my ken.  Therefore it's wrong.  A myth.  A black lie.  They're both crazy and mistooken.






      Absorb the good, ignore the bad, weigh the ugly.

      It's about number behavior.

      Egos don't count.


      Dedicated to the memory of Big Loooser


        RJOh's avatar - chipmunk
        United States
        Member #9
        March 24, 2001
        20166 Posts
        Posted: July 22, 2006, 11:30 am - IP Logged


        There's software that will do what you want but only one state at a time unless you combine all the results of each pick5 game into one large file.  Using Excel would required you to do the same which would require a lot of entries by hand.  Good luck to you.


         * you don't need to buy more tickets, just buy a winning one * 
                      Evil Looking       

          time*treat's avatar - radar

          United States
          Member #13130
          March 30, 2005
          2171 Posts
          Posted: July 22, 2006, 6:26 pm - IP Logged

          I didn't know this could be done w/ a regular formula like LC23 linked to, but wrote a macro to do a similar thing some time ago. The macro route takes a little more setup work, but it's just a matter of preference.

          In neo-conned Amerika, bank robs you.
          Alcohol, Tobacco, and Firearms should be the name of a convenience store, not a govnoment agency.

            winsumloosesum's avatar - Lottery-060.jpg
            United States
            Member #2218
            September 1, 2003
            5799 Posts
            Posted: July 22, 2006, 9:23 pm - IP Logged


            Sent you a PM.

            Can email you the Excel file.