How to Calculate Combinations ?

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..

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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 6 numbers

Thx for giving me this solution..

Greetz