How to Calculate Combinations ?

[Jacko]

Hi,
I want to see how much combinations are possible when i got 6
numbers..

-- got this numbers 1--2--3--4--5--6
-- want to calculate how much combinations of ( 2 ) numbers possible
-- want to calculate how much of ( 3 ) numbers possible
-- want to calculate how much of ( 4 ) numbers possible
-- want to calculate how much of ( 5) numbers possible

-- never 2 same numbers together (2-2) or (2-2-3) or (2-2-3-4) may not
be in list

-- How can i make the result visible in kind of list ?


I would be nice if somebody knows a good solution..

Greetings
Jacko..

 

[Bob Phillips]

Look up 'combinations Larson' on Google groups, Myrna has posted code to get
permutations and combinations.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Jacko]

i found the macro.. and it works fine ..

when put C it give me the numbers of combinations
when put P it give me all the combinations possible with the
numbers

Thx for giving me this solution..

Greet