Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check boxes
Hi, I wrote early but wanted to write to maybe clarify things. I have an
applications setup that is used for data entry and group assignment. I have three categories to fill out each with two subcategories. (+ or - weight, + or - height, and + or - sex). For each person interviewed they fall into a set of subcategories (ex. +weight, -height,+sex). Therefore, there are 8 different combinations that could be made with these categories. Depending on the 8 different combinations a person is assigned to a Group (ie. Bad or Good). So what I did was have two different worksheets for each Bad and Good. In each I made six columns for the different subcategories and put a counter for each colum. I made different formulas for each of the 8 combinations and I compare the number of combinations in the Bad and Good worksheets. I fill out the subject ID in each of the subcategories and my generator tells me which of the groups (Bad or Good) has the least number of people in it. This works perfectly, and my boss loves it, but he wants something simple. He wants me to put check boxes that automatically put in the Subject's number in each of the categories. Therefore I want to have colum for each Subject I enter, with it's own checkbox that fills in "1" in 3 different columns so that my counter continues to work. So instead of filling out a number 3 times, a simple check box will fill it out for me. Can I do this? Have I run into a dead end. I don't want to change the lay out for my worksheet because it runs great the way it is. If I have to, I'd be willing. Hope I can find some help. Thanks. -Jose M. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
check boxes
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Check Boxes | Excel Discussion (Misc queries) | |||
Can one cell hold multiple check boxes (and then sort based off e. | Excel Discussion (Misc queries) | |||
why do check boxes move when printing excel spreadhseets | Excel Discussion (Misc queries) | |||
Selecting Check Boxes | Excel Discussion (Misc queries) | |||
How to align check boxes on an Excel sheet? | Excel Worksheet Functions |