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                            www.energyefficientbuild.com
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