Welcome Guest

### NetConnect

#### Internet Domains, simple and cheap

##### Find a domain name:

Home

You last visited May 22, 2015, 7:27 am
All times shown are
Eastern Time (GMT-5:00)

# Excel formulas for Pick 3 & 4 help needed

Topic closed. 6 replies. Last post 9 years ago by powerplayer.

 Page 1 of 1

United States
Member #17834
June 28, 2005
2074 Posts
Offline
 Posted: November 24, 2005, 2:00 am - IP Logged

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 easy 1234 pick 4 # and 6 for pick 3. The pick 3 I'm doing prettty good on and have done almost all 1,000 combinations ...yes this was a lot of work!!! for all of mid-day draw in November. I want to make this formula do more so I can do less manually. I need the formula to search for all 6 or 3 combo's for pick 3 and then well if this can be done then the pick 4 will be a snap!!

I did make one formula:

=SUM(ISNUMBER(FIND("123",B3:S21))*1,ISNUMBER(FIND("132",B3:S21))*1,ISNUMBER(FIND("213",B3:S21))*1,ISNUMBER(FIND("231",B3:S21))*1,ISNUMBER(FIND("312",B3:S21))*1,ISNUMBER(FIND("321",B3:S21))*1)

This one can do all 6 combinatons at once but, ever time I save and then reopen excel it doesn't seem to save the location it searches. So all my work is being done and then gone in a matter of seconds when I close excel.

Any help would be great!!

Below is a example of the way I chart my pick 3 for mid-day only!! I don't do seperate cells in excel I put all 3 digits in one cell. Not sure if this is harder but, from what I can see from othe people they track 1 number per cell.

Good till 11/21/05 did get a chance to update fully yet.

Also below this is a list of what I have been able to get for best combo's hitting so far across all states. I'm only listing a couple because to long to paste.

 State 11/1/05 11/2/05 11/3/05 11/4/05 11/5/05 11/6/05 11/7/05 11/8/05 11/9/05 11/10/05 11/11/05 11/12/05 11/13/05 11/14/05 11/15/05 11/16/05 11/17/05 11/18/05 11/19/05 11/20/05 11/21/05 Month of November 2005 California Mid-Day 4:00pm 063 519 076 437 162 187 971 238 847 213 261 430 613 193 657 649 464 161 079 495 296 Connecticut Mid-Day 1:57 pm 411 566 832 798 n/a n/a 047 673 411 325 527 n/a n/a 718 307 904 208 018 n/a n/a 245 DC Mid-Day 1:45 pm 337 497 610 112 743 125 073 685 734 317 785 897 370 702 959 022 785 992 682 275 615 Deleware Mid-Day 1:25 pm 417 951 647 130 390 n/a 731 009 235 322 240 604 n/a 958 688 590 786 249 900 n/a 103 Georgia Mid-Day 12:14 236 804 626 052 347 n/a 888 197 196 523 175 285 n/a 405 184 377 286 965 747 n/a 197 Illinois & Iowa Mid-Day 1:25 & 1:20 780 080 519 276 350 n/a 123 752 121 488 780 756 n/a 995 696 959 519 150 053 n/a 984 Indiana Mid-Day 1:00 834 629 468 508 795 n/a 829 890 863 920 709 350 n/a 928 658 929 002 888 719 n/a 304 Kentucky Mid-Day 1:10 544 310 317 985 889 n/a 963 239 624 020 862 451 n/a 563 312 063 710 381 355 n/a 110 Maryland Mid-Day 12:13 399 563 246 695 501 396 193 109 168 003 767 835 477 611 734 880 481 703 911 444 242 Michigan Mid-Day 12:24 816 565 639 052 673 845 212 801 167 508 382 524 312 326 550 992 448 631 391 028 675 Missouri Mid-Day 1:40 529 155 623 851 027 990 336 317 067 787 466 460 755 955 079 105 759 763 011 918 922 New Jersey Mid-Day 12:40 894 559 472 431 811 152 097 702 721 470 902 460 181 425 352 569 785 609 059 461 438 New York Mid-Day 12:10 501 019 640 509 411 185 619 060 043 199 667 772 589 713 197 459 467 074 105 742 385 Ohio Mid-Day 12:14 977 325 753 150 891 n/a 089 297 088 924 331 351 n/a 582 892 656 769 856 770 n/a 751 Pennsylvania Mid-Day 12:50 302 157 733 359 567 644 664 117 882 482 364 769 251 379 125 416 656 188 724 476 331 South Carolina Mid-Day 12:30 925 106 884 259 304 n/a 321 156 508 254 208 129 n/a 261 505 602 142 716 483 n/a 785 Texas Mid-Day 1:00 365 042 177 535 138 n/a 439 122 575 324 956 244 n/a 453 048 606 047 290 074 n/a 641 Tri-State Mid-Day 12:50 586 598 198 159 415 889 417 659 683 771 670 676 178 194 011 537 841 247 628 653 824 Virginia Mid-Day 1:38 949 220 074 620 284 n/a 945 569 662 299 604 761 n/a 465 490 800 248 156 306 n/a 678

 123 1 132 0 213 1 231 0 312 2 321 1 Total 5
 137 0 173 0 317 3 371 0 713 1 731 1 Total 5

 268 0 286 1 628 1 682 1 826 0 862 1 Total 4

 047 2 074 3 407 0 470 1 704 0 740 0 Total 6

 015 0 051 0 105 2 150 2 501 2 510 0 Total 6

This seems like the best double so far: ( I believe it came out today 11/23/05...not updated on this)

 567 1 576 0 657 1 675 1 756 1 765 0 Total 4

Enjoy all

Powerplayer

Good luck to everyone!!!

Pennsylvania
United States
Member #1340
April 6, 2003
2444 Posts
Offline
 Posted: November 24, 2005, 1:26 pm - IP Logged

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.

Playing more than one ticket per game is betting against yourself.

Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
 Posted: November 24, 2005, 2:02 pm - IP Logged

Powerplayer, are you trying to search for

ex: all ways of 123

123,132,213,231,312,321

if 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.

L ttaL   T

Charlotte NC
United States
Member #17406
June 18, 2005
4043 Posts
Offline
 Posted: November 24, 2005, 2:10 pm - IP Logged

Powerplayer, are you trying to search for

ex: all ways of 123

123,132,213,231,312,321

if 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.

Lottaloot, will you give us those two formulas?

takeemtothebank

United States
Member #17834
June 28, 2005
2074 Posts
Offline
 Posted: November 24, 2005, 2:33 pm - IP Logged

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:

 047 2 074 3 407 0 470 1 704 0 740 0 Total 6

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 470 I figure I have a better chance of winning on those combo's in that order.

For box it doesn't matter but, you can also play 3 of the 6 combo's and if it hits well triple your money. Same goes with straight.

Even doing this with one state works really well but, out of the 6 hits this month up till the 21st I have hit on this # 4 TIMES by doing this.

I'm playing the hot combo. It's a new way for me not sure if any one else has tried this.

If I can keep my formula with the right location to look at with out it changing every time I close excel it would be a lot easier to keep track.

The formula I had up above =SUM(ISNUMBER(FIND("123",B3:S21))*1,ISNUMBER(FIND("132",B3:S21))*1,ISNUMBER(FIND("213",B3:S21))*1,ISNUMBER(FIND("231",B3:S21))*1,ISNUMBER(FIND("312",B3:S21))*1,ISNUMBER(FIND("321",B3:S21))*1)

Does the 123 as a example in all combinations but, it doesn't stick with the location. It changes depending on what cell I have it in.

Thank you for you help

Powerplayer

Time for dinner. I hope I don't miss to much while I'm gone.

Good luck to everyone!!!

ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
4702 Posts
Offline
 Posted: November 24, 2005, 6:13 pm - IP Logged

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)

 047 3 074 3 470 3 407 3 740 5 704 3

United States
Member #17834
June 28, 2005
2074 Posts
Offline
 Posted: November 24, 2005, 6:52 pm - IP Logged

Thank you Carbob. I will try this tonight at work.

Looking foward to getting this done.

Powerplayer

Good luck to everyone!!!

 Page 1 of 1