Thread: Permutations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Permutations

Hi,

In the UK lottery of 49 numbers 6 numbers makes a line. Our lottery
syndicate would like to enter every possible combinattion of 9 numbers (or
possibly 10). It's easy to work out that any 6 from 9 is 84 combinations ( 6
from 10 = 210) but it's much harder to work out what those combinations are.
At least it is if you have to guarantee accuracy because potentially a lot of
money rides on it.

So, the question is if i enter the 9 numbers in Excel can it work out and
list the 84 combinations?

D