Hi! Please help me create the Excel formula we need to rank the results of a poll to decide on a new team name. I really appreciate it!!
We don't have the final results yet ... I'm just developing the Excel sheet to calculate the winner and realize I don't know how to properly weight the results.
Important details:
1. 3 separate polls have been sent out, with the exact same response options (SurveyMonkey capped the number of responses at 100 per poll).
2. Respondents have 4 possible team names to choose from and put them in order of preference (1st, 2nd, 3rd).
3. It is not mandatory to select 3 names, but they cannot choose more than 3 of the 6 and can only choose 1 for each position (1st, 2nd, 3rd).
Thanx in advance for your help!! Preliminary results are:
We don't have the final results yet ... I'm just developing the Excel sheet to calculate the winner and realize I don't know how to properly weight the results.
Important details:
1. 3 separate polls have been sent out, with the exact same response options (SurveyMonkey capped the number of responses at 100 per poll).
2. Respondents have 4 possible team names to choose from and put them in order of preference (1st, 2nd, 3rd).
3. It is not mandatory to select 3 names, but they cannot choose more than 3 of the 6 and can only choose 1 for each position (1st, 2nd, 3rd).
Thanx in advance for your help!! Preliminary results are:
Angels | Angels | Angels | Braves | Braves | Braves | Giants | Giants | Giants | Reds | Reds | Reds | |
1st | 2nd | 3rd | 1st | 2nd | 3rd | 1st | 2nd | 3rd | 1st | 2nd | 3rd | |
List 1 | 3 | 0 | 1 | 0 | 2 | 2 | 2 | 0 | 0 | 0 | 4 | 1 |
List 2 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 2 |
List 3 | 0 | 3 | 0 | 1 | 0 | 3 | 1 | 1 | 1 | 0 | 3 | 2 |