Others

How to Compare and Rank Microsoft Forms Poll Responses

Nimra Malik Oct 9, 2026 868 views

Question details

The user needs a method to compare multiple questions and rank respondents based on their total 'Yes' votes.

Product: Microsoft Forms
Device & OS: not provided
Scenario: Analyzing survey or poll results to determine which respondents had the highest number of specific answers across multiple questions.
Observed behavior: Microsoft Forms successfully displays the number of Yes/No responses for individual questions, but it lacks a built-in feature to automatically compare multiple questions or rank individuals by their total votes.

Before you start

Ensure that your Microsoft Form has finished collecting responses and that you have a spreadsheet program, such as Microsoft Excel or WPS Spreadsheet, installed on your computer to process the exported data.

Solution 1Recommended

Export Data to a Spreadsheet and Calculate Totals

Since Microsoft Forms does not support native cross-question comparison or respondent ranking, exporting the raw response data to a spreadsheet is the most effective way to analyze the results.

While Microsoft Forms is excellent for gathering poll data, its built-in analytics only summarize data on a per-question basis. To rank individuals by their overall responses, you will need to utilize the counting and sorting features of a spreadsheet application.

Export Responses

Open your Microsoft Form, navigate to the 'Responses' tab at the top, and click on 'Open in Excel' to download your poll data as an .xlsx file.

Insert a Calculation Column

Open the downloaded file in your spreadsheet software. Insert a new column next to your question columns and name it 'Total Yes Votes'.

Use the COUNTIF Formula

In the first data cell of your new column, enter a COUNTIF formula. For example, if the responses for a person span from column B to E, type =COUNTIF(B2:E2, "Yes") and press Enter. Drag the fill handle down to apply this formula to all respondents.

Sort the Data to Rank

Select your entire data table. Go to the 'Data' tab, select 'Sort', choose your 'Total Yes Votes' column, and sort from 'Largest to Smallest' (Descending) to generate a ranked list of respondents.

Export Data to a Spreadsheet and Calculate Totals

Submit a Feature Request: If you frequently need built-in comparison tools directly within your polls, you can submit a feature request to Microsoft by clicking the feedback icon in the bottom right corner of the Microsoft Forms interface.

Analyze Data with WPS

Calculate and Rank Poll Responses Using WPS Spreadsheet

You can seamlessly open your exported Microsoft Forms data and perform advanced ranking using WPS Spreadsheet. It provides a lightweight, user-friendly environment to count specific responses and sort your data in seconds.

1. Open Your Downloaded Data: Launch WPS Office, select 'Spreadsheet', and open the .xlsx file you exported from Microsoft Forms.
2. Set Up a Total Column: Add a new column header named 'Total Score' or 'Total Yes Votes' next to your response data.
3. Apply the Counting Formula: Use the formula =COUNTIF(Range, "Yes") to count the target answers for the first respondent, then drag the cell downwards to calculate totals for everyone.
4. Rank Respondents: Highlight the 'Total Yes Votes' column, navigate to the 'Data' tab, and click the 'Descending' sort button to automatically rank the list from highest to lowest.

100% compatibility with Microsoft Excel (.xlsx) files downloaded from FormsBuilt-in support for COUNTIF, COUNTIFS, and advanced data sorting featuresFree and lightweight alternative to heavy spreadsheet applicationsClean, intuitive interface requiring no extra learning curve

Frequently Asked Questions

Can Microsoft Forms automatically calculate a score instead of just recording Yes/No?

Yes, but you must use the 'Quiz' format instead of a standard 'Form'. A Quiz allows you to assign point values to correct answers, which automatically calculates a total score for each respondent upon submission.

Is it possible to share the live ranking results with survey respondents?

Microsoft Forms does not have a built-in feature to share live ranking dashboards. To share rankings, you must export the data, sort it in a spreadsheet program, and then manually share the spreadsheet or a screenshot of the final results.

How do I count multiple different options at once?

If you need to rank people based on multiple criteria (e.g., both 'Yes' and 'Maybe' responses), you can use the COUNTIFS function in your spreadsheet or simply add two COUNTIF formulas together, such as =COUNTIF(B2:E2,"Yes") + COUNTIF(B2:E2,"Maybe").

Office Quick Solutions