Saturday, July 23, 2011

Yogi_Count Text Votes In A Column To Find The Winner In The Associated Category

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
cbrentlane said:
Counting text votes in a column to find the winner?
I created a form with GoogleDocs to vote for superlatives for kids at a camp I am working at.
Now, I want to figure out how to harness the power of the spreadsheet to find the winner in each category
In the following ... In the ResponseTable associated with the Form submittals, I inserted a computedField (WINNER) column for each category as shown with brown colored background