Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. A Very Big Thanks in Advance. Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sorting groups in groups due to subtotaling | Excel Worksheet Functions | |||
Excel 2007 - "Snap To Grid" doesn't work on same grid line | Excel Discussion (Misc queries) | |||
Grid lines in Excel not showing.Have tools,options,view/grid cked | Excel Discussion (Misc queries) | |||
I need to convert grid.doc to an Excel Grid. | Charts and Charting in Excel | |||
how do i view all groups under excel in google groups | Excel Discussion (Misc queries) |