Thanks Geoff, I appreciate it.
-----Original Message-----
Brandy:
Both of the questions you're asking are pretty straightforward. Here goes:
1) The combo box. First thing is to choose a range ON
THE SAME WORKSHEET that contains the values you want for
your combo box.
2) Once you have those cells filled out, go to the first
cell where you want to have the combo box.
3) Go to your Data menu, and choose "Validation."
4) Under "Allow," choose "List."
5) You'll then be prompted to select the cells, just as
if you were inserting a function. Select the cells from
Step 1.
6) You'll then see a combo box in the cell. If you want
to copy the combo box to additional cells, do this:
a) Copy the cell that has the combo box
b) Select the cells where you want to put it
c) Go Edit->Paste Special, and choose "Validation."
Now, for part two of your question - how to figure out
how many times an answer was chosen:
1) Go to the last cell in the range(if you had the
answers in rows 1-10, for example, you could go to row 11.)
2) Go Insert->Function
3) Choose the function type Statistical. The function you want is called "COUNTIF."
4) The first argument is the range of cells you want to
count. For example, if the answers were in A1:A10, then
the first argument would be A1:A10.
5) The second argument is the answer. For example, if
the four answers were Red, Blue, Green, and Yellow, then
the second argument might be "Yellow." It is important to
put the word in quotes. Case, however, is not important.
6) Repeat the process as many times as you need to for
the other answers. If you have multiple answers you want
to count in the same range, consider doing an absolute
reference ($A$1:$A$10, for example) in the function's
first argument, so if you copy and paste the Yellow
formula for the other colors, then it keeps the same cells.
Don't put yourself down...you're not lame or a dummy.
Everyone has to learn this. Good luck.
Cheers,
Geoff Lilley
MCDST, Microsoft Office Master Instructor (2000/XP),
Microsoft Office Specialist Master (2000/XP)
