Hi,
I'm trying to figure out a way of counting yes and no votes against a list
of items. I have 5 sets of lists and have done the formula to make a random
option from each list be chosen. Now I would like to have a button which
acts as F9 to make the choices appear, then I would like a 'yes' button and a
'no' button which when selected against the suitability of the random
selection puts a vote against all the options in that selections.

So, for example, when the options randomly chosen by pressing the F9 button
are a, b and c, and these are suitable so 'yes' is selected, then a, b and c
all show one vote against them etc.

Let me make this clear:
1. In your example, a is one of the values from list 1, b is one of
the values from list 2 and so on? Thus, a will always appear in the
same column?
2. You want to know how many times a appears in its column and the row
where it appears has a Yes? The Yes goes to the entire combo of 5
values each value gets an individual vote?
3. In the end, you want a number, next to each element of each of the
source lists, showing the Yes votes for that value?

HTH
Kostis Vezerides

On Oct 18, 6:51 pm, Teri H <Teri
wrote:
Hi,
I'm trying to figure out a way of counting yes and no votes against a list
of items. I have 5 sets of lists and have done the formula to make a random
option from each list be chosen. Now I would like to have a button which
acts as F9 to make the choices appear, then I would like a 'yes' button and a
'no' button which when selected against the suitability of the random
selection puts a vote against all the options in that selections.

So, for example, when the options randomly chosen by pressing the F9 button
are a, b and c, and these are suitable so 'yes' is selected, then a, b and c
all show one vote against them etc.