Search

excel formula neededReply
I use the formula below to count how many times a number occurs on a given day=SUMPRODUCT(--(Cash3History!A2:A141=V38),--(Cash3History!D2:D141=U39))A2:A141 contains a reference to day of the week (Sun thru Sat)V38 contains the day I am currently interested in (Sun thru Sat)D2:D141 contains the numbers I am looking at (single position)U39 contains a reference to the number I am looking for.=========================================================Also, you could use the following formula if you ar
Feb 10, 2005, 1:03 pm - SirMetro - Lottery Discussion Forum

Some information about PowerballReply
Bertil,I keep my own stats for PB in an excel sheet, a simple series of countif() functions are all you need to obtain your own frequency data, by selecting the ranges, you can get this data overall (as posted on the PB site) and by position.my newest sheet is frequency by date... shows the climb of frequencies with each draw with a rolling count... sort of a scrapbook of where frequency data was when a certain draw went off, hasn't really helped in getting any closer to winning, but it is inter
Oct 10, 2004, 12:21 pm - hypersoniq - Lottery Discussion Forum

Open Discussion: Define/Refine PredictionReply
Still trying to figure out how to count skips in excel... Had been reading about using a COUNTIF formula with the INDIRECT formula, but no luck so far in actually implementing it (they didn't provide an example). Anyone have any other ideas?
Dec 28, 2003, 7:41 am - hypersoniq - Pick 3 Forum

666Reply
just simple excel formulas, once the formula is written (an IF test to prdvent carrying the 1 in the thousands column) it's simply a matter of autofill, took longer to type the IF statement than to fill and recalculate all 10 steps in the rundown, then another IF statement to see if any of the rundowns matched the drawing... if so they put an X in a column... then just countif the x's :-)simple to a fault, I still don't know how to test for BOX hits, so right now I'm just finding the straight hi
Dec 20, 2003, 8:53 pm - hypersoniq - Lottery Discussion Forum

Open Discussion: Define/Refine PredictionReply
Quote: Originally posted by WIN D on November 30, 2003 Hyper....wish you would describe this some more ....sounds interesting.ok, start off with your entire history in columns (1st ball, 2nd ball, 3rd ball)beneath the list, I put the excel formula=MODE(A2:A9100) ' for example... A2 because of the header row and 9100 represents the end of the history listnow just autofill left and you have the mode for each position. I keep the number side by side in 2 formats, one is each number in posi
Nov 30, 2003, 2:30 pm - hypersoniq - Pick 3 Forum

Pick 4 - The 4 out of 7 TechniqueReply
IMPORTANT COD UPDATE emty cell stay empt on sheet 3 adding code C and updating code A tip. u can hide colums also . A B C D E F G H date 0 2 2 1 4 1 DOUBLE date 1 2 3 4 4 0 SINGLE date 0 0
Dec 9, 2008, 3:18 am - Mark J - Lottery Systems Forum

Florida: 11/1 - 11/30/2008Reply
jgdr, you dont need database of most overdrawn pairs it is easy to find any result in excel history CORRECTION TO ROW 3 IS F4 A B C D 6-Nov-08 6 8 0 5-Nov-08 0 1 0 4-Nov-08 2 6 9 3-Nov-08 3 9 7 2-Nov-08 3 2 3 1-Nov-08 2 2 5 31-Oct-08 6 1 8 30-Oct-08 3 7 4 29-Oct-08 1 7 6 E FGHIJKLMNOPQRSTUVWXYZ 1: 0000000000111111111 pairs down row 1to2 2: 0123456789123456789 3: =COUNTIF(F4:F100,2) = RESULT for pair 00 repe
Nov 6, 2008, 11:41 pm - Mark J - Pick 3 Forum

Florida: 11/1 - 11/30/2008Reply
jgdr, you dont need database of most overdrawn pairs it is easy to find any result in excel history A B C D 6-Nov-08 6 8 0 5-Nov-08 0 1 0 4-Nov-08 2 6 9 3-Nov-08 3 9 7 2-Nov-08 3 2 3 1-Nov-08 2 2 5 31-Oct-08 6 1 8 30-Oct-08 3 7 4 29-Oct-08 1 7 6 E FGHIJKLMNOPQRSTUVWXYZ 1: 0000000000111111111 pairs down row 1to2 2: 0123456789123456789 3: =COUNTIF(A4:A100,2) = RESULT for pair 00 repeat accross only 4: =COUNTIF($B1:$D1,F1)+C
Nov 6, 2008, 11:36 pm - Mark J - Pick 3 Forum

2 billion random numbers and none of them matched the last draw
(I love this new 64-bit workstation!) The game's MM, and here's the spreadsheet (Excel 2003 SP2): The first 56 columns are 56 random numbers using =RAND()*RAND()/RAND(). This should make certain all 56 numbers are different. The next 56 columns are the rank of the random numbers using =RANK(A1,$A1:$BD1) in cells BE1 through DH1. The next five colums are the first five of the ranked in numerical order using =SMALL($BE1:$BI1,1), =SMALL($BE1:$BI1,2), etc. Then I did five =IF stateme
Apr 5, 2007, 12:58 pm - m3g4m1ll10ns - Lottery Systems Forum

Excel Rank formulaReply
=(IF((A2 0),RANK(A2,$A$2:$J$2),(RANK(A2,$A$2:$J$2,1)+COUNTIF($A$2:$J$2, 0 )))+COUNTIF($A$2:A2,A2))-1 You will need to change the column in the formula or copy and paste this formula to cell a3 and then copy cell a3 in b3 thru j3 with the formula paste. 0 1 2 3 4 5 6 7 8 9 3 0 0 0 0 3 9 14 14 9 5 7 8 9 10 6 3 1 2 4 By the way, Thank You CarliG
Apr 14, 2015, 1:25 pm - theo1946 - Lottery Systems Forum