survey

  1. L

    INDEX MATCH LEFT for first 25 characters (all text)

    I conducted a survey and I am trying to return a value using index match. I am realizing that some of the text of the survey has been edited, so my index match isn't finding what it needs to. I thought I would have a better return rate if I instead of matching the whole cell, I would match just...
  2. V

    Generate Chart of a Survey which will count the ratings and group them for specific metric

    Hi All, I will try my best to explain my situation. I've a file with the following data: +------------------+------------------+------------------+------------------+------------------+ User Metric A Metric B Metric C Metric D...
  3. J

    Score a Likert Scale Survey

    I have a Survey of 17 questions regarding specific companies. I need to create a score for each company. The questions are grouped into 3 areas, weighting of 40%, 40% and 30%, using the Likert scale of 5 responses for each question. Based on the score of each area, I came up with where each...
  4. J

    Survey selection visual markers

    I am trying to create a clickable survey/grading form and would like to have a red circle encompass a cells contents when selected as pictured below. Any ideas on how to make this work? I will have approximately 10 questions, each with the below graphic following it.
  5. S

    Star Trek Vs Star Wars Survey Yes No Maybe in Excel VBA

    I am trying to make a yes no maybe survey Star Trek as Yes and Star Wars as No and No Pref as maybe. This is how far I have got I am also tallying the totals in field A1:C2 <tbody> A B C 1 Star Trek Star Wars No Pref 2 0 0 0 </tbody> Private Sub btnOK_Click() Dim intSelection...
  6. J

    Merge Data From Multiple Columns - Sharepoint Survery Results - VBA

    Hello, I am using SharePoint to collect data through its survey feature. However, I want to make the output data more manageable. As such, I want to take the multiple columns and consolidate them into a few. Currently, it looks like this: Name 1 Address 1 Age 1 Name 2 Address 2 Age 2 Name 3...
  7. S

    Run Macro on OneDrive survey input LIVE

    Just found out about OneDrive's Excel Survey feature. Great... Is it possible to run some code to process the data as surveys are completed. Live and online that is, rather than having to do from desktop excel. Advice much appreciated.
  8. T

    Excel to Sharepoint Survey

    Ok, I have a scenario that I have searched and searched on and have not been able to come up with a good solution. I'm really hoping someone here can help me. I have two items, a macro-enabled excel workbook and a sharepoint site survey. What I want to be able to do is... 1. Create a...
  9. D

    Creating a Survey or Vote

    I'm trying to create a worksheet for a Luncheon choice in our workcenter. I would like to offer 4 choices, each user clicks on a choice and at the end I can calculate the winning choice. Maybe I haven't had enough coffee but I can't even remotely figure this out.
  10. A

    Need help on multi-level pivot summry

    Hi all, I need help on a survey table that is of following format. Sr# contains 318 rows and there are 30 columns named 1 through 30. I want to create a summary using 'pivot table' that helps me in identifying how many questions have an answer 'a', 'b', 'c', 'd', and '0'. Would appreciate a...
  11. N

    Arranging Excel Data For Survey Analysis

    Hey all, I am currently a student who is partaking in compiling my survey results. I want to pair the variables up in a row so that i am able to see a person's data more properly as shown by the table below. Ideally this is what i want to achieve. <colgroup><col><col><col></colgroup><tbody>...
  12. B

    Automatically Convert Survey Results to Word

    My school district is moving from Google Apps to Office 365 and I am trying to find out if Office 365 will be able to accomplish a task. In Google forms I created a survey and after someone completed the survey a "script" was automatically run and it would take the responses and place it into...
  13. R

    Survey with more than 2 options

    Hey guys/gals, I followed a youtube video on setting up a survey in excel, and it works great, but it was only for two options. I wanted to make it 5 options per question, but when I started adding to the code ( which I thought was correct, but was not ) I kept getting errors. It probably is a...
  14. W

    Update worksheet surveys based on changes to a "master sheet"

    I have a survey built, which I need to fill out 14 times. Each time the survey is filled out it needs to be on it's own worksheet. The survey, however, is still being refined, so I need any text changes to the root/master sheet to carry through to all the survey sheets. A microsoft query and...
  15. K

    VBA Survey Issues, Mismatch 13 Error Code

    Hello! I am super new to creating VBAs in Excel and in fact this is my first attempt. I am trying to create a survey and what happens is when someone leaves a spot blank when they submit the survey then a Message Box will populate advising that need to go back to that question and fill in the...
  16. A

    Survey Submission Results - Only Allow Submitter to Answer Question Once (Column)

    I've stretched my brain enough on this problem, figured I'd finally sign up and ask the experts. I have a set of survey data: <tbody> Submitter Q1 Q2 Q3 Q4 aaronchiles Pear Apple Banana Peach aaronchiles Apple johndoe Apple Pear Peach johndoe Banana </tbody> Each submitter can...
  17. J

    Help with Match/Vlookup/HLookup formula

    Hi All, I am having difficulty determining what type of formula to use for a problem I have. I have a range of surveys that include a start and end time on a specific date. I also have a spreadsheet with an extract of device availability. What I am trying to do is return a "Yes", "No" or...
  18. K

    1,000 missing survey data points to be fixed by interpolation

    Hello experts, Tried all methods without success I have large data of around 10,000 drainage pipe segments and 10,000 junctions in ArcGIS layer The problem is: due to some reason certain junctions could not be accessed for survey, thus 1,000+ entries are missing for pipes (up stream and d/s...
  19. B

    Survey Values Question

    Can someone please help! I am creating a spreadsheet to analyze the data of a survey. For each question of the survey there are 5 options that can be chosen as an answer, and each of the 5 answers have a numerical value that correspond with them ie: Very Poor=1, Poor=2. Fair=3, Good=4, Very...
  20. S

    How to Tabulate Survey?

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...

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