March 22, 2004
|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:
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 |
|Arizona||Fantasy 5||Fri, Jul 21, 2006||02-03-08-09-20|
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!
|State || Game || Draw Date || Results ||1||2||3||4||5||6||7||8||9||10|
|Arizona||Fantasy 5||Fri, Jul 21, 2006||02-03-08-09-20|| ||X||X|| || || || ||X||X|| |
|California||Fantasy 5||Fri, Jul 21, 2006||01-11-22-23-29||X|| || || || || || || || || |
|Colorado||Cash 5||Fri, Jul 21, 2006||05-20-22-31-32|| || || || ||X|| || || || || |
|Connecticut||Cash 5||Fri, Jul 21, 2006||04-11-22-27-30|| || || ||X|| || || || || || |
|Florida||Fantasy 5||Fri, Jul 21, 2006||06-07-11-18-29|| || || || || ||X||X|| || || |
March 10, 2005
|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
March 24, 2001
|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 ticket *
March 30, 2005
|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.
September 1, 2003
|Posted: July 22, 2006, 9:23 pm - IP Logged|
Sent you a PM.
Can email you the Excel file.