Excel formula

Reply #12

winsumloosesum — Sun, 04 Apr 2010 00:44:47 GMT

Thanks Bob,

I kind of figured that.

Reply #11

CARBOB — Sat, 03 Apr 2010 19:10:05 GMT

Steve, it works, but it works faster the original way. A million rows is a lot of rows!!!! lol

Reply #10

winsumloosesum — Sat, 03 Apr 2010 17:01:11 GMT

Carbob can you test this also by changing the VBA Code and re-run?

Let me know if it worked.

Thanks

Reply #9

winsumloosesum — Sat, 03 Apr 2010 16:59:55 GMT

Thanks Carbob

For Excel 2007 owners you can change the following code:

' Verification of number of combinations posted

' and move to top of next column if 65,000

If N = 65001 Then

Selection.ColumnWidth = 15

N = 1

ActiveCell.Offset(-65000, 1).Select

Application.ScreenUpdating = True

Application.ScreenUpdating = False

ActiveCell.Value = Combinations

End If

Change to:

' Verification of number of combinations posted

' and move to top of next column if 1... [ More ]

Reply #8

CARBOB — Sat, 03 Apr 2010 14:54:09 GMT

Steve, the macro works. In 07, you will have 59 columns X 65,000 rows.

Reply #7

winsumloosesum — Sat, 03 Apr 2010 13:56:57 GMT

If someone that has Excel 2007 would run the Macro to see if the combinations are generated would be appreciated. This may take about 10 minutes to complete for 3 million plus combinations of a 5/56 game.

Excel 2007 grid is 1,048,576 rows by 16,384 columns so you could not list all 3 million plus combinations in 1 row. It would be 3 plus rows vs the 58 rows for Excel 2002 version with 65,000 combinations per row. Not if it makes a difference.

If someone who has Excel 2007 would run the Mac... [ More ]

Reply #6

winsumloosesum — Sat, 03 Apr 2010 03:01:22 GMT

This is the response to your 2nd question:

Below I circled how many combinations number 45 are in Postion 4 = 145,684. In addition all 56 numbers combinations by positions 1 through 5. This does not include Bonus Ball which of course would make the number of combinations larger.

Reply #5

winsumloosesum — Sat, 03 Apr 2010 02:48:25 GMT

Here is the new download link:

http://www.box.net/shared/yh4f1vdzqk

Reply #4

rindo — Fri, 02 Apr 2010 14:48:28 GMT

I get the message that this link has been removed. Is there a new link?

Thanks

Reply #3

frenchie — Fri, 02 Apr 2010 02:30:38 GMT

Thank you for your prompt response to my question but what Im looking for is to have all the combinations, all 3million plus, individually on a Excel sheet with the formula that creates them. Thank You very much for all your help

Reply #2

winsumloosesum — Thu, 01 Apr 2010 07:06:04 GMT

Here is the download link to an Excel file that contains a Macro that will generate all 5/56 into 57 to 58 columns each column holding about 65,000 combinations. Does NOT include Bonus Balls)

http://www.box.net/shared/b27fms0gll

1. Download the Excel file

2. Open the file

3. Go to the main Menu and select Tools Macro Macros and then highlight the Macro then click Run. Depending on the speed of your computer it may take about 10 minutes to complete. May help to close all open programs... [ More ]

Reply #1

winsumloosesum — Thu, 01 Apr 2010 06:28:50 GMT

Hey Frenchie,

I'm using Excel 2002 and have a limit of 65,000 or so cells per columns so over 3,819,816 is a bit much.

Here is an Excel file with all the totals based on your request.

http://www.box.net/shared/vq8xgqnfbq

The answer to your question is there are a total of 145684 combinations if the number 45 is in the 4th position. Of course this does not include bonus balll calculations. The calculations in the Excel file are based on a 5/56 game with no bonus ball.

Hope this is... [ More ]

Excel formula

frenchie — Thu, 01 Apr 2010 04:39:22 GMT

Hi everyone,

I need help ; Is there a formula that would create all the combinations for the mega millions game ( 5/56 ) by draging it all the way to 3,819,816 in a numeric order ? I'm working with Excel 2007 Thank you.

My second question : Is there a formula to compt how many combinaitions it would be by position of the number ? for exemple for the ( 5/56 ) game if the number 45 is the 4th place in the combinaition of 5 how many combination would that be ?

I realy apreciate any... [ More ]