Search

need excel guru & master
Dear Lottery Post Member, guru & excel master please help me with macros cause i don't familiar with those step, only a simple function :) the file sysp34.xls are sunday draw with month febuary from 1987 (SG4D lottery) download link: zip format http://www.rapidupload.com/d.php?file=dl&filepath=9720 excel format http://www.rapidupload.com/d.php?file=dl&filepath=9721 please copy the link& paste to your internet browser it's need a lot of step to all lottery state, ple
Feb 3, 2006, 5:25 am - sysp34 - Lottery Systems Forum

January list- times hit & notReply
Tenaj, you probably have a program that does this (but it's not the same program) as I put this spreadsheet together myself using the =sum(countif(... feature in excel. I am becoming quite the wiz with excel. (not great, but I can make it do the simple things that I want
Jan 22, 2006, 10:04 pm - lottaloot - Pick 3 Forum

Need excel formulaReply
thank you big time, LL.......have a great day. Not really what I want but will play with it.....not interested in sums....just the count...I think it is a COUNTIF command or a COUNT command.In the gray area, why can't I just sort with the decending order AZ thingie on the tool bar?
Jan 14, 2006, 9:17 am - Sandy K - Lottery Discussion Forum

SoniQ BOOM, a new P3/P4 system (Excel)Reply
Soniq, I too made the changes of losing the -1 looking for the number pairs' matches by using the previous line. Here's the code I use for identifying a tie.=COUNTIF(Q3418:Z3418,AA3418)This is for the first digit it replaces the row AB which is previously unused. I then added conditional formatting to turn the background rose colored, if and only if it counts a tie.Hope you like it, Pogo
Jan 6, 2006, 11:01 am - Pogo - Lottery Systems Forum

Trying to figure out formula forReply
I think I'm getting closer (thanks to whoever spoke on naming ranges in another thread) I named my columns H:M where my pairs are (Pairs) =COUNTIF(pairs,AN2) To count the number of times the pairs are seenNow do I simply divide by the draws to obtain the % that each pair hits?
Dec 11, 2005, 7:18 am - lottaloot - Lottery Discussion Forum

Excel formulas for Pick 3 & 4 help neededReply
powerplayer, I hope I understand your question. $B17:$B3992 = COLUMN WHERE list of draws are, AT18 = Combo you're searching for. Enter fomula in cell next to the combo you're searching for, then drag fill the other 5 cells.Carbob =COUNTIF($B$17:$B$3992,AT18) 047307434703407374057043
Nov 24, 2005, 6:13 pm - CARBOB - Mathematics Forum

Got formulas-- need help intrepreting
=MATCH(TRUE,MMULT(--(H2:M4=TEXT(O1, @ )),TRANSPOSE(COLUMN(H2:M4)*0+1))>0,0)-1or=MATCH(TRUE,COUNTIF(OFFSET(H2:M4,ROW(H2:M4)-MIN(ROW(H2:M4)),0,1),O1)>0,0)-1where O1 would contain the pair of interest.It's a CSE formula. Any excel experts to intrepret this for me prehaps make an easier formula --because I did not write thisgot an excel genie to do it for me but they have no time to explain it to me.And I can't make it work until I know how it works well, I can but I don't like not knowing
Jun 29, 2005, 10:19 pm - lottaloot - Lottery Discussion Forum

At a standstill until I can getReply
So far what I have come up with are listed below=MATCH(TRUE,MMULT(--(H2:M4=TEXT(O1, @ )),TRANSPOSE(COLUMN(H2:M4)*0+1))>0,0)-1or =MATCH(TRUE,COUNTIF(OFFSET(H2:M4,ROW(H2:M4)-MIN(ROW(H2:M4)),0,1),O1)>0,0)-1...where O1 contains the number of interest, such as 36Of course, I did not write these formulas so I need a bit of help intrepreting them.Any volunteers????
Jun 29, 2005, 10:07 pm - lottaloot - Lottery Discussion Forum

Lottaloot system set-upReply
Thanks Lottoloot, I appreciate you sharing your worksheet. I ran into a problem:The countif formulas that you have in Column R are not working for me. Have I done something wrong. The other formulas are working fine.Bolade'
Jun 22, 2005, 4:57 pm - mybolade - Pick 3 Forum

analyzer.......Reply
flaboiTry this:Enter this formula into a cell outside the range you wish to analyze.=COUNTIF(CELL1.CELL2,5)where Cell 1 is the upper left limit of the range you wish to analyze and Cell 2 is the lower right limit of the range you wish to analyze.Punctuation must be correct.glj
May 25, 2005, 7:32 pm - johnph77 - Lottery Systems Forum