P
Paul Black
Hi Everyone,
I will try and explain simply what I would like to achieve.
I have a Macro that produces combinations ( it produces them in memory
and then inserts them into the Active Sheet ). I ONLY want
Combinations ( with 6 Letters in each combination ) that appear in ANY
Two Groups as Per the Grid ( the Grid Structure could possibly change
) below :-
Example Grid :-
Group 1 - A,F,K,O,S,W
Group 2 - B,G,L,P,T,X
Group 3 - C,H,M,Q,U,Y
Group 4 - D,I,N,R,V,Z
Group 5 - E,J
So A,K,W,P,M,Q and K,S,B,X,D,I would be EXCLUDED. In addition I would
also like to be able to, instead of having ALL Six Letters in ONLY ANY
Two Groups, maybe have the Option to put the Scenario - 4 Letters in
One Group and the Other Two Letters in ANY OTHER Two Groups for
example or whatever. I want to have the different Groups ( A,F,K,O,S,W
etc ) Hard Coded in the Macro and Exclude combinations that do NOT
meet the Criteria.
Apologies for Posting this again, I posted it this morning and it was
fine, then at about 18.30 GMT it appeared to have vanished.
A Very Big Thanks in Advance.
Paul
I will try and explain simply what I would like to achieve.
I have a Macro that produces combinations ( it produces them in memory
and then inserts them into the Active Sheet ). I ONLY want
Combinations ( with 6 Letters in each combination ) that appear in ANY
Two Groups as Per the Grid ( the Grid Structure could possibly change
) below :-
Example Grid :-
Group 1 - A,F,K,O,S,W
Group 2 - B,G,L,P,T,X
Group 3 - C,H,M,Q,U,Y
Group 4 - D,I,N,R,V,Z
Group 5 - E,J
So A,K,W,P,M,Q and K,S,B,X,D,I would be EXCLUDED. In addition I would
also like to be able to, instead of having ALL Six Letters in ONLY ANY
Two Groups, maybe have the Option to put the Scenario - 4 Letters in
One Group and the Other Two Letters in ANY OTHER Two Groups for
example or whatever. I want to have the different Groups ( A,F,K,O,S,W
etc ) Hard Coded in the Macro and Exclude combinations that do NOT
meet the Criteria.
Apologies for Posting this again, I posted it this morning and it was
fine, then at about 18.30 GMT it appeared to have vanished.
A Very Big Thanks in Advance.
Paul