Search

Lock and LoadReply
Ive noticed that on the ohio classic 6 sheet the countif is only counting 5 lines not 6 ie cf23 countif v23:z23=1 cd 23 countif ab23:af23=1 shouldnt it be cf23 countif v23:aa23? also all the numbers are wrong and I cant figure out how to change them. I tried to clear all on the dump page and paste in the numbers I posted here but that doesnt change the numbers on the main sheet. Also Im getting an error when using paste although that does seem to use the last entry on the dump page. Debugg
Feb 2, 2010, 10:30 am - nickbrownsfan - Lottery Systems Forum

Need an excel routine for comparing numbers from row to rowReply
Let's say your first row has numbers in cells A1 to T1, your second row has numbers in cells A2 to T2, your formula in cell U2 should be = SUM(COUNTIF(A1:T1,A2:T2)). Then hit Ctrl-Shift-Enter to finish. Your formula should look like this {SUM(COUNTIF(A1:T1,A2:T2))}
Feb 20, 2009, 5:05 am - aspire - Mathematics Forum

Xcel formula questionReply
Is this what you're looking for? 15222644221 Enter the formula as an Array, Ctrl-Shift-Enter. Change the bold range to your sheet! =(COUNTIF($W18:$AA18, <19 ) COUNTIF($W18:$AA18, <38 )-COUNTIF($W18:$AA18, <19 ) COUNTIF($W18:$AA18, >37 ))+0 Hope this helps!!
Jul 1, 2007, 7:58 am - CARBOB - Mathematics Forum

need excel programReply
first 3? I could do that easily...86 times the first 3 matchedyou can do it easily too..the sheet I gave you, in cell BY3 enter=COUNTIF(BT3:BV3, x )autofill this to the last draw down the BY columnyou will see where I have the count of pick4 matches in cell BZ10141in cell BZ10140 enter=COUNTIF(BY3:BY10141,3)it's that easy ;-)
Jan 1, 2006, 4:55 pm - hypersoniq - Lottery Systems Forum

Matrix for Pick3Reply
PS... to tally the number of hits...enter in the next blank row in cell AA...=countif(AA2:AA2300, S )and one cell below that...=countif(AA2:AA2300, B )to count the boxes tooautofill the 2 cells across to AI and you have complete hit data!enjoy and remember to play responsibly... also if anyone has any ideas on how to strike duplicates... feel free to chime in ;-)Thanks for the idea! hopefully I can find a new june pet side project...
May 29, 2004, 11:55 am - hypersoniq - Lottery Systems Forum

Do you use Excel for playing?Reply
there is a great function called countif...you can mark your excel spreadsheet with the winners, and then countif the values, and then organize the values looking for different F.F....and bottoms... its easy. I personally taught T*T and SM everything they know about this... = countif(Range,0) Just kidding guys.
Aug 3, 2012, 4:15 pm - LottoBoner - Mathematics Forum

Lottaloot system set-up
I have decided to share my system since there are so many people requesting their state be done. Now you can do your own. If you can tweak this, please do so let us all know. Also, if you can share numbers within the forum that you obtain from this-Please do so. To set up in excel B1(DATE) C1 (DRAW) D1 (a) E1(b) F1(c)Column G has been made to become width .17 Add to Column H1 thru M1 ( ab, ac, ba, bc, ca, cb )O1(root)P1(sum)Q1(Doubles)R1(pairs)S1(Singles or whatever you wish to call other
Jun 22, 2005, 12:35 pm - lottaloot - Pick 3 Forum

To SedertreeReply
I have always found number generation and backtesting easier in excel for workouts. You can see the whole process and propagate changes and tweaks with immediate visual feedback with autocomplete...here's a pick3 example...=IF(G2=(($D2*100)+($E2*10)+$F2), S ,IF(G2=(($D2*100)+($F2*10)+$E2), B ,IF(G2=(($F2*100)+($E2*10)+$D2), B ,IF(G2=(($F2*100)+($D2*10)+$E2), B ,IF(G2=(($E2*100)+($D2*10)+$F2), B ,IF(G2=(($E2*100)+($F2*10)+$D2), B , ))))))This assumes you separated your digits for each draw in c
Sep 5, 2004, 8:54 am - hypersoniq - Mathematics Forum

My Pick-4 Work Out 1 2 3 1Reply
emilyg... here's what I have figured for pick 3, I still need to mod it for pick 4...(Thanks to ERAE for the help inspiration, formula sharing is cool! hope you like my mods)=IF(S2=(($D3*100)+($E3*10)+$F3), S ,IF(S2=(($D3*100)+($F3*10)+$E3), B ,IF(S2=(($F3*100)+($E3*10)+$D3), B ,IF(S2=(($F3*100)+($D3*10)+$E3), B ,IF(S2=(($E3*100)+($D3*10)+$F3), B ,IF(S2=(($E3*100)+($F3*10)+$D3), B , ))))))Assumes S2 contains the first result of your workdownAssumes D3, E3 and F3 contain the next day's result
Dec 22, 2003, 10:26 pm - hypersoniq - Pick 4 Forum

Open Discussion: Define/Refine PredictionReply
I'm no further in the prediction process, but for all the excel -erators hre, this is a simple formula for excel to backtest for straights and boxes when doing a multi-step rundown (a la Julian Dates added to last draw or 111+last draw, etc)...=IF(S2=(($D3*100)+($E3*10)+$F3), S ,IF(S2=(($D3*100)+($F3*10)+$E3), B ,IF(S2=(($F3*100)+($E3*10)+$D3), B ,IF(S2=(($F3*100)+($D3*10)+$E3), B ,IF(S2=(($E3*100)+($D3*10)+$F3), B ,IF(S2=(($E3*100)+($F3*10)+$D3), B , ))))))Assumes S2 contains the first resul
Dec 22, 2003, 10:20 pm - hypersoniq - Pick 3 Forum