Need some excel expertise

Reply #11

Ricklou — Sun, 16 Sep 2012 17:10:46 GMT

Thanks Phileight

Reply #10

phileight — Sun, 16 Sep 2012 16:55:37 GMT

did not get PM. sent you one

p8

Reply #9

Ricklou — Sun, 16 Sep 2012 16:49:03 GMT

Very weird.......Macro run but I dont get the answers.Can I possible mail you the spreadsheet I have Phileight ? Tried to send u a pm but I dont think u got it

Reply #8

Ricklou — Sun, 16 Sep 2012 16:44:00 GMT

Macro is still running.......Just pmed you Phileight...Thank you for your expert programming skills. Can see you are a FUNDI!!!!!

regards

Ricklou

Reply #7

phileight — Sun, 16 Sep 2012 16:29:00 GMT

the result is 6 numbers. the result is in col D,E,F,G,H, I. starts on line 5 and moves down 1 line for each match

Reply #6

phileight — Sun, 16 Sep 2012 16:24:32 GMT

Ricklou

Correction to the code above. for r=5 to 48 change the 6 to a 5

you need to add data for col A,B, and C. I don't have your database so I can't calculate the skips

this program simply loops thru all possible combinations of skip. for each loop it adds the skips indicated in col B associated with the variables R,S,T,U,V, W. If the total matches the number in c5 then it displays the numbers in col A indicated by variables R,S,T,U,V,W

good luck

Reply #5

Ricklou — Sun, 16 Sep 2012 16:23:49 GMT

All the results should be in Column D2-D49

Reply #4

Ricklou — Sun, 16 Sep 2012 14:53:00 GMT

Phileight

Yes I know and know the basics -I am no programmer thats why I need some expertise from an excel guru like yourself. Correct Column A = Numbers A2-1- 49

Column B2 Skips for each ball 1-49 (note these skips can have repeat numbers up to 6 repeats) C2=Target. So A1 B1 C1 =Headings so all the data begin on A2 B2 C2. I know there is also solver dont know if that can do it. And yes there will be lots of options to get to the target -whats important is that the formulae need to be... [ More ]

Reply #3

phileight — Sun, 16 Sep 2012 10:24:42 GMT

Ricklou

you mention a macro so you know your way around a spreadsheet. can I assume you are taking care of columns A,B,C ? you do realize that you could have many thousands of matches? you show col C to be on line 5, but your wording says col 1. I will assume everything starts on line 5.

i let the code below run for 5 min using random data. 30000 matches later and not even a third of the way done. good luck

Sub Button1_Click()

Ln = 5 'line for display

For r = 6 To 48

For s... [ More ]

Reply #2

SergeM — Sat, 15 Sep 2012 19:51:32 GMT

Someone posted a link for a free E-book VBA Excel. Good luck with it

Reply #1

Ricklou — Sat, 15 Sep 2012 19:43:44 GMT

Example previous draws skips was 36

So C1=36

So need 6 balls values -repeats combinations aswell that can add to 36..Just clearing it up.Thanx for any help hope someone can assist

Need some excel expertise

Ricklou — Sat, 15 Sep 2012 19:41:09 GMT

Need a macro or a way to callcalate all the possible balls skips for 6 balls etc there is repeat nrs aswell that it will list all the nrs that could add up to the total skips for the draw. Column A (balls)1-49, Column B5 skips for ball1-49 Column C1 =Total that the 6 skips should be equal too. Column D1 =all the numbers that will equal to C1.

Balls Game Out

Column A Colum BSkips Column C Column D

1 8 36

2 3

3 5

4 1

5 5

6 14

7 11

8 5

49 3