Excel formulas for Pick 3 & 4 help needed

Reply #6

powerplayer — Thu, 24 Nov 2005 23:52:41 GMT

Thank you Carbob. I will try this tonight at work.Looking foward to getting this done.Powerplayer

Reply #5

CARBOB — Thu, 24 Nov 2005 23:13:42 GMT

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

Reply #4

powerplayer — Thu, 24 Nov 2005 19:33:20 GMT

Yes Lottoloot that is excatly what I'm trying to do except not by box by best combination hitting so I can narrow down which combo hit more and what would be a good straight.So for example:047207434070470170407400Total6 This # has been hot across the states.6 hits in 21 days. Not bad!! Remeber this is mid-day only.So I know now that 074 seems to be a good way to play the # but, also 704 and 740 have not come out yet across states. See where I'm going with this. So if I bet 074 straight 047 and 4... [ More ]

Reply #3

Tenaj — Thu, 24 Nov 2005 19:10:52 GMT

Lottaloot, will you give us those two formulas

Reply #2

lottaloot — Thu, 24 Nov 2005 19:02:07 GMT

Powerplayer, are you trying to search forex: all ways of 123123,132,213,231,312,321if so, you might want to just have a formula within your spreadsheet that changes your draw results into the boxed format within a second column---that way you can search for the number in boxed format.

Reply #1

hypersoniq — Thu, 24 Nov 2005 18:26:53 GMT

not sure why it isn't saving, but in the interim, you should copy and paste your most used formulas (that won't save) into a notepad .txt file and just paste them back in when working with the excel file.

Excel formulas for Pick 3 & 4 help needed

powerplayer — Thu, 24 Nov 2005 07:00:10 GMT

Hello All,I have a formula =SUM(ISNUMBER(FIND( 520 ,B3:AE21))*1) that I use in excel. It's able to take a and find one # for either pick 3 or 4 across all parts of a excel sheet. I have been doing this formula for all combinations to see what is coming out the most. This is good for straights I figure or even boxes to narrow things down.My question I have is 1. Does any one know how to expand this formula to be able to search all combinations at once? I know there are like 24 combo's just for a... [ More ]