Consolidating survey results excel

-There are 22 worksheets -Each worksheet has 10 datapoints (cells A1: A10) -These datapoints are either 1,2,3,4,5 I want to (in the simplest, non-vba way possible) consolidate the data on another sheet to show: (if you can help with any of the below, it would be VERY much appreciated) -all data (10 rows deep, going from columns A: V) -the frequency of each answer THANK YOU SO MUCH!

Sheet22), then it will be easy, otherwise you may need to process one sheet at a time or use VBA.

Change the word Sheet in the formula to match the text part of the name of your sheets.

Also assumed that you coincide the rows with the rows of each data sheet.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site. It's not possible to merge the results of two separate surveys, even if they are identical in design or copies of one another.If you need to merge the data of two separate surveys, export the data for each survey and try combining the files in Excel.To use formulas to consolidate the list of responses, first place the unique responses into a range, as shown in C2: C4 in the table at left. In cell D2, enter this formula: Copy cell D2, select D3: D4, and paste to complete the consolidated table.To create a bar, column, or pie chart, select this range or any single cell in the range, and run the chart wizard.

Search for consolidating survey results excel:

consolidating survey results excel-35consolidating survey results excel-19

You have a column of text values, such as the list at left. You would like to plot these values, but an Excel chart cannot create a sensible chart from such a range.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “consolidating survey results excel”