Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 394
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel - Sorting groups in groups due to subtotaling [email protected] Excel Worksheet Functions 3 April 4th 08 06:13 PM
Grid lines in Excel not showing.Have tools,options,view/grid cked bajlearning Excel Discussion (Misc queries) 6 January 28th 07 02:00 AM
I need to convert grid.doc to an Excel Grid. suavejohn Charts and Charting in Excel 0 September 1st 05 06:26 PM
how do i view all groups under excel in google groups JulieD Excel Discussion (Misc queries) 2 December 16th 04 04:33 PM
Set Groups for Custom Grid Paul Black Excel Programming 0 May 28th 04 11:01 AM


All times are GMT +1. The time now is 04:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"