View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teri H Teri H is offline
external usenet poster
 
Posts: 2
Default Counting yes/no votes

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.