respondents

  1. B

    Sort a range of numbers (including an asterisk) with an asterisk as the lowest

    I have two columns of data. The first is a count of respondents. The second is the average score for those respondents. I need to sort the second column into numerical value, highest to lowest. So far, so simple. The area I am having an issue with is that if the number of respondents is less...
  2. P

    Lock particular cells in a worksheet

    Hi, I am using excel for a survey which I will send out via email to respondents and want to - Prevent them from adding rows and or columns - Only be able to enter data in selected cells - Also write some rules/conditions that will appear with a prompt (i.e I ask respondents how they split...
  3. rjbinney

    Stacking Columns

    My Google skills have found ways to combine multiple columns into ONE column; I'm trying to figure out how to do TWO columns. Basically, I have received data from a survey. Every other column is the Question on the survey, then the next column is the Answer. (i.e., |Q1|A1|Q2|A2|Qn|An|). Each...
  4. W

    Survey Questions, If/And/Or?

    Hello, I conducted a survey on people's emotional well-being after they had received a emotional counselling service. I asked respondents 5 separate questions on how effective the counselling service was with 7 response options: - Strongly agree - Agree - Neither agree or disagree - Disagree -...
  5. K

    Index Match to return second matching value from row 12

    I'm working with a survey dataset that needs to be aggregated for analysis purposes. Right now I'm looking to identify all instances where different respondents answered a question with the same numeric answer from a multiple choice list, the number of respondents who answered with the same...
  6. M

    Creativity Survey - Originality of Text Data

    Hi, I'm trying to analyse some data for a creativity survey. Respondents were asked to generate as many ideas for a film title. I have around 4000 different responses, and I want to assess the uniqueness of each one by finding out the percentage of respondents that said the same, or a very...
  7. M

    Sumproduct/countifs with mulitple criteria pair

    Hi I have conducted a survey and data is according to following table.. I have data of more than 10K respondents. I want to count how many respondents are satisfied. then i want to apply different filter -criteria pair (one, two or more) to analyze the satisfaction across different groups...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top