[mso] Re: Check for repeating combinations?

Robert,

There's an article available on my website which gives an introduction
to dynamic range names. Go to www.grbps.com/articles.htm and view the
article called 'Excel Performance Analysis the Professional Way'. That
should get you started.

Ray 

_____________

This email is from Ray Blake, Head of Software Design, GR Business
Process Solutions. It is confidential and intended for the addressee
only. The contents are private and may be legally privileged. If you
receive this email in error we would be grateful if you would advise the
sender and delete the email from your system.

For more information on the services that we offer please visit us at
our website: - www.grbps.com 



-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Robert Carneal
Sent: 27 December 2003 15:57
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Check for repeating combinations?


<Copy>
If you want to make a formula which will grow as the table of data does,

you could used dynamic named ranges. Let me know if you want to go that
way 
and I'll help you do it.
<End>

Ray, I would like to do this please.

It may help you to know what I am doing. I received two filing cabinets 
+stuffed+ to the gills on family historical data. (Birth, marriage, 
divorce, death, newspaper clippings, etc.) I have begun schematically 
filing them, and started running into people for whom I did not have a 
first name for, had a bad date, etc. I began to look for a way to print
a 
small label  (like the color coding scheme doctors use in their
offices).

Green Green Green for example means the file folder has everything in it
I 
want it to.
Green Lavender Red means I know this person has a brother, but no 
information on the brother.
Blue Pink Red means I know this person has another spouse, but I have
not 
found the name of that spouse yet.
Green Blue Red means that person has a new child, but I don't have the 
child's name yet.
Lt. Blue, Green Green means cemetery correspondence, and it is complete.

See the pattern? Whenever the label ends in Red, I know at a glance I do

want to work on it. Then, I can grab a bunch of them without caring
which 
ones I grab, and go to the research center and just work through them. I

assigned the colors in such a way it tells me at a glance what is
missing, 
or what it is that I want to do for that folder.

I thought about just buying the colored tabs, but the ones sold here are

huge, about an inch in width, and using three colors would be three
inches 
wide! I bought some blank address labels 5/8s of an inch and my color 
printer will print three colors on that.

If I have done my permutation calculation correctly, having ten colors
and 
using two colors to classify a folder, plus Green or Red to indicate if
the 
folder needs working on, gives me 360 combinations. That is way more
than I 
will need or use. So, yes, I would appreciate a chance at fixing this so

the formula will grow as the table grows. What do I need to do?

Thank you.

Robert


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: