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)

Post by 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..
--
Jacko
------------------------------------------------------------------------

http://www.excelforum.com/member.php?action=getinfo&userid=28762

Post by Jacko
View this thread: http://www.excelforum.com/showthread.php?threadid=484509

[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

--
Jack
-----------------------------------------------------------------------
Jacko's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2876
View this thread: http://www.excelforum.com/showthread.php?threadid=48450