[mso] Re: Check for repeating combinations?
- From: "Ray Blake" <ray@xxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 27 Dec 2003 18:57:22 -0000
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).
//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).
//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:
