Excluding numbers
 

Objective: create a program (with VBA) that allows me to exclude number
in a logical way.

Details: I've got 100 sets of 7 numbers each. In this 100 sets ther
are 30 sets that, if we exclude them (along with their numbers), we ge
the next set.
I've been thinking about this problem for a while and i know, almos
for sure, that there is only one combination of these sets that mak
this possible!
As we add up more new sets, we take the oldest out. This results in
dynamic "set of sets". And we get always different combinations of set
to exclude.

If this isn't clear enough but you think you have the solution,pleas
post it and I will try to clear it out.

Thank you very much for your attention

Nun

--
Message posted from http://www.ExcelForum.com

Excluding numbers
 

I don't have a solution set, but I could set up somethinh if you set a reply
with a clearer explanation.
Maybe you want to supply some example data :)

Rob


"PeaceMaker " wrote in message
...
Objective: create a program (with VBA) that allows me to exclude numbers
in a logical way.

Details: I've got 100 sets of 7 numbers each. In this 100 sets there
are 30 sets that, if we exclude them (along with their numbers), we get
the next set.
I've been thinking about this problem for a while and i know, almost
for sure, that there is only one combination of these sets that make
this possible!
As we add up more new sets, we take the oldest out. This results in a
dynamic "set of sets". And we get always different combinations of sets
to exclude.

If this isn't clear enough but you think you have the solution,please
post it and I will try to clear it out.

Thank you very much for your attention

Nuno


---
Message posted from http://www.ExcelForum.com/

Excluding numbers
 

PeaceMaker,

You say the 4th set should be eliminated, but I'm thinking you made a
mistake and it should be the 5th.
If that holds true, then this formula would do it:
=0=COUNTIF($A$12:$G$12,A1)+COUNTIF($A$12:$G$12,B1) +COUNTIF($A$12:$G$12,C1)+C
OUNTIF($A$12:$G$12,D1)+COUNTIF($A$12:$G$12,E1)+COU NTIF($A$12:$G$12,F1)+COUNT
IF($A$12:$G$12,G1)

Then fill it down.


Rob


"PeaceMaker " wrote in message
...
Take this as an example:

14 34 36 50 54 90 18
4 6 36 38 62 88 34
4 26 32 48 88 98 74
4 26 40 60 64 72 44
12 18 22 30 82 84 92
16 18 24 40 52 94 28
24 28 34 36 44 96 80
20 46 68 80 92 96 38
12 26 34 40 60 98 96
2 8 12 38 70 90 20


We've got 10 sets of 7 numbers each. They go from 2 to 98. There are
only pair numbers.

In my opinion, there is a way to eliminate the numbers that won't come
out in the next set.

Imagine that the next set is: 4 - 6 - 28 - 48 - 58 - 66 - 74
In this case the 1st, 4th, 8th, 9th and 10th sets would be eliminated
(not randomly but logically).

Got it?
If the answer is NO... :(


---
Message posted from http://www.ExcelForum.com/

Excluding numbers
 

Yes, it's the 5th and not the 4th that should be excluded. My mistake.

About the formula, i will try it and i will post the results.

Thanks


---
Message posted from http://www.ExcelForum.com/