Mega Millions

Reply #22

adulane62 — Sun, 12 Aug 2012 19:23:12 GMT

Your tag line says it all. unfortunately, the path you are trying to clear leads to nowhere! A newbie to excel, perhaps? Would you be so kind to post a video on youtube to explain this idiotic nonsense? Thanx.

Reply #21

billybouy — Sun, 12 Aug 2012 11:07:31 GMT

Hi every one, here is where they came on Fri, highlights at the top of the columns indicate the filters.

Regards,

billybouy...

https://www.box.com/s/cd70da1f5474f7f34f98

Reply #20

billybouy — Fri, 10 Aug 2012 12:19:14 GMT

Hi Blowhard,

I don't gamble, all I can tell you is it is consistent with repetitive routines.

Hope this helps.

Regards,

billybouy...

Reply #19

BlowHard — Fri, 10 Aug 2012 05:10:29 GMT

How much money have you won with your sheet and filter

Reply #18

billybouy — Thu, 09 Aug 2012 06:47:50 GMT

The Mega sheet is updated.

Regards,

billybouy...

https://www.box.com/s/cd70da1f5474f7f34f98

Reply #17

billybouy — Wed, 08 Aug 2012 18:29:06 GMT

Hi lakerben,

You are probably right, but then I am no good with code, so until I am ready it stays the way it is unfortunately.

Regards,

billybouy...

Reply #16

lakerben — Wed, 08 Aug 2012 18:16:09 GMT

I speak American most of the time. Wouldn't it be easier to just re-program this to filter all at once and show a list of the picks

Reply #15

SergeM — Wed, 08 Aug 2012 14:42:58 GMT

I tell you what it is.

Sheet 2 is basically skip-chart, which doesn't work by itself. There is no formula and no code. Sheet 2 is incomprehensive as correct headers are missing. There are no guidelines. The use of the sheet isn't defined to get to a selection.

Sheet 1 contains drawing information. There is no connection to sheet 2. The information is in one column and formulas don't work on this.

The creator of the workbook is unknown. There are formulas missing.

Reply #14

billybouy — Wed, 08 Aug 2012 13:35:05 GMT

Hi flossdog, go to the link, and follow the Red highlights on the row numbers, it will teach you or anyone else how to filter the A,B,C. and arrive at your selections, just follow the Red highlight and try and remember what filter you use, there is repetitive routines that are consistent all the time.

Regards,

billybouy...

https://www.box.com/s/cd70da1f5474f7f34f98

Reply #13

billybouy — Wed, 08 Aug 2012 12:33:42 GMT

Hi flossdog, go to the first group at the start of the sheet, then filter A, then filter B, then filter C, that will give you the three filters, from your first selection in A, continue to the second A, and filter the same to that one, B, C, then do the the third A, and continue, the A,B,C. from the first group pair with the A,B,C. from the second group, and the answer is in there, you can also go to the end and filter 1 from the first group and pair with 1 from the second group.

Everything o... [ More ]

Reply #12

flossdog — Wed, 08 Aug 2012 12:03:25 GMT

man..I must be dense. What do you mean filter A,B,C. How do you filter? 3 filters per group? etc. etc, I am totally lost

Reply #11

billybouy — Wed, 08 Aug 2012 10:03:32 GMT

Hi lark, there is an example of how the MM finished on the update I have done, it shows that you pair group one with group two, on the first part of the sheet you have to filter A,B,C. three filters per group, on the last part of the sheet you only need 1 filter per group, and A from group one pairs with A,B,or C. in group two, B, in group one pairs with A,B, or C. and so on till you are finished, on the end of the sheet there are plenty columns to use for your Marks, or in between the first 2 g... [ More ]

Reply #10

lark — Wed, 08 Aug 2012 04:35:42 GMT

Would someone be kind enough to post an example on how we are to fill in our information?

Are we to place our selections (guesses) on the data sheet (BD thru BG) and see if they fall under the filters on sheet 2?

Sorry... I still don't get it either.

Reply #9

flossdog — Tue, 07 Aug 2012 23:21:32 GMT

still don't get it.

Reply #8

SergeM — Tue, 07 Aug 2012 19:42:15 GMT

This workbook has been posted long time ago already.

Reply #7

billybouy — Tue, 07 Aug 2012 07:18:22 GMT

Hi everyone, a further update has been uploaded, with changes to the last 2 groups,see if it helps.

Regards,

billybouy...

https://www.box.com/s/cd70da1f5474f7f34f98

Reply #6

billybouy — Mon, 06 Aug 2012 10:58:13 GMT

Hi lark,

you have filter A,B,C, in the first group, and the pair them to A,B,C,

in the second group, that is on the first part of the sheet, on the second part you only need 2 filters one in the first group and 1 in second group, there are approximately 8 numbers come out with the wining numbers in them, it is not for the faint hearted, but the answer is in there...

Regards,

billybouy...

Reply #5

lark — Mon, 06 Aug 2012 10:47:59 GMT

I must be missing a lot...or I am very dumb... How do I use this

Reply #4

billybouy — Mon, 06 Aug 2012 10:19:29 GMT

Hi Keke242,

Many thanks for rating, you obviously see what I see.

Regards,

billybouy...

Reply #3

billybouy — Mon, 06 Aug 2012 08:10:48 GMT

The Mega files are updated ready for Tuesday.

Regards,

billybouy...

https://www.box.com/s/cd70da1f5474f7f34f98

Reply #2

billybouy — Sun, 05 Aug 2012 19:06:26 GMT

No problem, your are welcome.

Regards,

billybouy...

Reply #1

Keke242 — Sun, 05 Aug 2012 19:01:38 GMT

Thank you

Mega Millions

billybouy — Sun, 05 Aug 2012 18:50:10 GMT

Hi everyone, here is the file on M.M, the Red highlights are Mega, and the Blue are Power Ball, the numbers are coming out on the Mega Data, interesting, use it as you do the Power Ball.

Regards,

billybouy...

https://www.box.com/s/cd70da1f5474f7f34f98