[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
*************************************************************

Other related posts: