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
------------------------------------------------------------------------
Jacko's Profile: http://www.excelforum.com/member.php...o&userid=28762
View this thread: http://www.excelforum.com/showthread...hreadid=484509

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" wrote in
message ...

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
------------------------------------------------------------------------
Jacko's Profile:
http://www.excelforum.com/member.php...o&userid=28762
View this thread: http://www.excelforum.com/showthread...hreadid=484509

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...fo&userid=2876
View this thread: http://www.excelforum.com/showthread.php?threadid=48450