Set Groups for Custom Grid
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 |
All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com