Excluding numbers

  • Thread starter Thread starter PeaceMaker
  • Start date Start date
P

PeaceMaker

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
 
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
 
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 ar
only pair numbers.

In my opinion, there is a way to eliminate the numbers that won't com
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 eliminate
(not randomly but logically).

Got it?
If the answer is NO... :
 
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)+COUNTIF($A$12:$G$12,F1)+COUNT
IF($A$12:$G$12,G1)

Then fill it down.


Rob
 
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
 
Back
Top