Microsoft Excel Number Combinations

  • Thread starter Thread starter FLYNNE
  • Start date Start date
F

FLYNNE

In Microsoft excel 2002 one of the functions is the COMBIN
function.
This calculates the number of groups of x in a larger
group of y.
For example how many groups of two objects can you get in
a total group of 6 ?
Insert =COMBIN(6,2) in a cell and the answer is 15.
Consider the following list of numbers :-

2 , 9 , 14 , 16 , 29 , 35

Can excel calculate all the possible pairs of numbers in
this list and print out or display the result as follows.

2 9
2 14
2 16
2 29
2 35
9 14
9 16
9 29
9 35
14 16
14 29
14 35
16 29
16 35
29 35

Any suggestions please

Regards

Flynne
 
Hi Jerry

Thank you for your prompt and detailed reply.
There is quite a bit of information to get through from
the sites you supplied.
I will let you know how it turns out.

Regards

FLYNNE
 
Back
Top