View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Combinations Sequence

Thanks everyone for the replies.

Gary''s Student,
Yes, 10 09 07 03 09 05 is a valid sequence of numbers.
All of the numbers in the six sets could possibly be the same to start
with, i.e. 10 10 10 10 10 10.
I am only interested in the combinations and not the permutations.

Thanks in Advance.
All the Best.
Paul

On Apr 23, 10:34*am, Gary''s Student
wrote:
Can there be repeats??

is:

10 09 07 03 09 05

a valid sequence??
--
Gary''s Student - gsnu2007h



"Paul Black" wrote:
Hi,


I would like to be able to list all the sequences of numbers using six
criteria.
The easiest way to explain it would be to say there are six jars, with
each jar containing anything from 1 to 10 counters.
Ideally I would like a list of all the sequences. So for example ...


10 09 07 03 02 05
10 08 07 05 01 09
01 03 08 10 04 10


... etc.


If it helps, I could put the actual counters that are in each jar in
cells A1:F1.
I know that the list will be quite long depending of the number of
counters in each jar.
The first combination would go in cells A3:F3, the second in cells
A4:F4 etc, etc.


Thanks in Advance.
All the Best
Paul- Hide quoted text -


- Show quoted text -