Traking all combinations

  • Thread starter Thread starter Maxi
  • Start date Start date
M

Maxi

X A B C D E F
1 1 2 3 54 60 65
2 2 3 4 55 61 66
3 3 4 5 56 62 67
4 4 5 6 57 63 68
5 5 6 7 58 64 69
6 6 7 8 59 65 70
7 7 8 9 60 66 71
8 8 9 10 61 67 72
9 9 10 11 62 68 73
10 10 11 12 63 69 74
11 11 12 13 64 70 75
12 12 13 14 65 71 76
13 14 15 66 72 77
14 15 16 67 73 78
15 16 17 68 74 79
16 17 18 69 75 80
17 18 19 70 76
18 19 20 71 77
19 21 72 78
20 22 73 79
21 23 74
22 24 75
23 25 76
24 26 77
25 27 78

I have 25 rows and 6 columns in the range A1:F25. Some of
the cells are blank.

Question:
---------
I want to make combinations of 5 numbers.

Criteria:
---------
1. There should be no duplicates in any single combination
of 5 numbers.
2. Every number in a combination of five numbers should be
taken from different columns.

For example:
1 5 8 20 26 is NOT a valid combination because numbers
given in the last three columns are not used.
8 12 21 55 58 is also NOT a valid combination because
numbers given in the last two columns are not used.

We can skip one column but not more than that.

Result:
-------
1. How many combinations can we get keeping the criteria
in mind?
2. Is it possible to automate this and see which are those
combinations?

Maxi
 
Thankx for the reference Peo but I am a newbie and I don't
understand UDF and programming stuff. Can anybody work it
out for me?
 
What are you doing? Is this some kind of lottery scheme?
Can anybody work it
out for me?
Click to expand...

You want someone to figure out all the combinations and mail them to you?
What are you asking for?
 
Back
Top