Macro/Code to get all possible combinations

**Jordans121** · 11-14-2010, 08:51 PM

I want to get all possible combinations for a pick 5 game with the numbers being 1-39. Hopefully this is can be done.

**JBeaucaire** · 11-14-2010, 11:41 PM

If you Google excel combinations and permutations you get thousands of options to aid you.

**Jordans121** · 11-14-2010, 11:54 PM

I've already tried that but cant find what I'm looking for

**JBeaucaire** · 11-15-2010, 12:11 AM

Took 5 minutes to Google this up...

http://www.ozgrid.com/forum/showthre...t=28321&page=1

**Jordans121** · 11-15-2010, 01:53 AM

i dont quite understand it even after reading it. I downloaded the sheet but the button does not produce anything.

**JBeaucaire** · 11-15-2010, 03:10 AM

Try it again. It's a long wait, though.

**Jordans121** · 11-15-2010, 03:43 AM

Thanks a million JBeaucaire !!!!! It actually only took about 10 secs

**JBeaucaire** · 11-15-2010, 03:56 AM

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

Re: Macro/Code to get all possible combinations